I work for a construction company, Someone else created a workbook a few years ago with 140 similar pages, each listing a separate piece of equipment as a service record. I need to print these out randomly for mechanics to update with new information, as they service the machines. However, some of the pages of the original workbook are goofy and the workbook as a whole could be improved. But, oh that many pages!
I have worked on a new template page for entering information to make the worksheets all cohesive and updated. Is there an EASY and/or FAST way for me to copy this page 150x to make a new workbook, and just enter my data onto each new page? I really don't want to reformat each page of the original workbook individually to see if I can fix all the glitches and weirdnesses that have occurred on the pages over the years. I thought it would be much easier to retype the data onto new pages.
I have a workbook that has a total of 128 pages. The problem is that a lot of those pages won't be used. Basically I have a sheet that needs to be filled out for each day up to around 30 days, sometimes more, most times less.
Currently I have created all the sheets that I will typically need (31 daily's, 31 daily printable reports).
Data is entered into the daily (and other spots) and then with the use of formulas transferred to the report sheet which is hidden and then printable with the use of macros.
I also need to withdraw some of this information (CSV File) to be able to populate a database.
Is it possible to have my "daily" page as a template and then create the subsequent pages as I need them? (this would have to be done with a bunch of other report pages as well). For ease of use I would need all the formulas etc that I currently have to be able to be "created" as well. As an example, there is a running total of costs associated with the "daily" pages that would need to be carried forward.
I'm trying to execute a macro and it won't put the focus (radio button) to select x pages wide by x pages tall in the Page Setup/Page/Scaling Area. I looked at the macro and can't find a setting in the code but yet the focus won't change. What can I do about this? In other words the radio button stays selected as "adjust to "" % of normal size. Here's the code...
I am trying to create a spreadsheet that will take all my grades from the semester (I'm a college student) and compute my GPA. I managed to get a weighted average for each class, but the grade is on a scale of 1-100. I need to convert that to a letter grade, and then a 4.0 scale. How can I set it up so that it will return "A" if 90<Grade<100, "B" if 80<Grade<90, etc.? I'm apologize if this is something simple, but I've been trying to find the right function for a long time.
I am having a little difficulty getting my vba to correspond to what i want it to do. I have columns that can vary with how many rows they have weekly. The all start at P2, R2, V2.
These columns always have the same number of rows as each other, but the number of rows varies.
I compare my R2>P2, and if it is return the number in R2. If not, i am looking to take P2 and round down to the nearest .95. (ex: R2 is at 3.45. The value that should be put in in V2 is 2.95. Since the values all change as well, it needs to compare: .96-1.95, 1.96-2.95, etc. all the way up to 15,000.
I know it can be done with if's, whiles, or from i to x, but my experience is in vb.net, not vba. And, since i am new at this, i can write the code, but don't know how to make it correspond to a new excel filename weekly.
My workbook is a variation of the below repeated on a number of sheets.
A B C
1 Name Carrots Peas
2 John Smith 0 7
3 John Doe 2 1
4 Joe Bloggs 4 0
On a separate summary sheet Im struggling to create a formula that would look through all sheets and Sum where 'John Smith' appears and then sum the number of 'Carrots' (if any) and 'Peas' and then the same for any other names that has values attached to it. The names in each sheet may not be in the same order or appear at all otherwise I would just use a standard sum on each sheet.
I believe in the past that I have told Excel to send the output of the pivot table to different worksheets. For example if I have three regions- the pivot table would send the output to three worksheets and name the worksheets with the three regions.
I am trying to produce numerous workbooks based on a filtered name. I will attach a sample spreadsheet that has the data.
On the sheet we have engineer names. I basically want to filter them (not difficult with a macro) but then to copy the results to a new spreadsheet and save the workbook as the engineers name (ie J. Bloggs has 5 jobs so they are filtered and the results are dumped into a new workbook and then saved as J. Bloggs.xls). This will happen for all engineers.
I have though about doing it as a macro and I think that would give me the end result but we have around 20 engineers and these can sometimes go up and down. Is there anyway to do this automatically?
In A1 I have a list. The list Manager, Assistant Manager, Casual In B1 I have a list of places America, UK, Mexico there are amounts in A3 A4 A5 and B3 B4 B5 If Manager is selected then America I would like A3 to display in C1 Depending on which variations are picked I would like the amounts to display in C1
I know how this formula which I've used before but I don't know how to include all the variations.
Let`s assume that I have numerous "Serial Number" in "Sheet1" : http://i40.tinypic.com/2iqbspt.jpg
Now I want to create some cards in "Sheet2" that each card have a serial number that related serial number there is in "Sheet1" : http://i43.tinypic.com/34fz690.jpg. Need easy solution for doing it while when I drag one card to copying it then related serial number in sheet1 would be appear in required field. I mean first card has first serial number of sheet1 and second card has second serial number of sheet 1 ; but I want to doing it quickly with dragging.
We use excel for scheduling purposes and each and every day we fill out a floor chart with who is working that day. As it stands now we have to print out a template and hand write all names or type them in and print it out. What I would like to try and do is define each set of names and allow for easy access to auto fill these names. I feel it needs to be a simple process as not all of our managers experienced in excel or formulas. What I would like to try an accomplish is in sheet 1 cell A1 to be able to create a drop list or formula that that would let me return all the names for a given day.
For the purposes of this discussion we can just define each list as the day that is the header ( IE A2:A4 on sheet 2 would be defined as "monday". Also, I already have the names autofilled based off of what the our schedule has. I'm curious if I could create a drop down list with each day of the week as an option, and if they select Tuesday it will then return all the names defined as Tuesday in a column below.And the next day be able to return Wednesday names and so on.
I'm not stuck on it being a drop down list. Maybe if they could just type and =(defined name) in the box above and it would return all the names.
I have tried an =(defined name) and it does return the value but only for the first cell and it has to be in the same row for it to return the name. Which doesn't work because I would like the names that are being defined on a separate sheet.
I have an excel template that needs to be copied multiple times and each sheet needs be named according to a list in an excel spread sheet. I also have a formula in the template that needs the value copied instead of the formula.
I got this script from an site and tried it. It runs but I don't see any spread sheets.
I have a workbook with numerous worksheets that contain text, steps actually. I would like to select all common words and change their formatting to bold. Every time I try however, it formats the entire cell in bold. Is there a way to isolate just the word "click" for instance in all the cells in each worksheet and change the formatting to bold, and leave the other text within the cell normal?
I have a website with lots of pages and I have a tool where I can see how many visits these pages get. What I want is to find out which pages didn't get any visits.
So I have in one column all the pages URL's on my site In the other column I have all the pages URL's that have been visited, and in the column right next to it I have the amount of visits that page has received.
For example, this is what it looks like today: column A: row 1: /site/hello.htm row 2: /site/how.htm row 3: /site/are.htm row 4: /site/you.htm
I am trying to create a PDF of every 2 Worksheets. I currently have this code that creates my PDFs for each individual sheet but I need it to group 2 together. Ex: Sheets 1 & 2 a separate PDF, Sheets 3 & 4 a separate PDF and so on.
I'm trying to find an easy way(or any way) that I can have excel automatically insert a page number into my document. I'm looking at 60+ pages on separate tabs that I will be adjusting and modifying for a few weeks yet and I don't feel like continually fixing page numbers.
I have a user form that has several tab pages on it when the form opens it checks to see if the user has entered there default info if it is empty it needs to go to the default tab so the user can enter there info. How do I do this using vba in excel 2000 I have not been able to find any code that will do this if I use the set focus option for a text box on the tab page it comes up with an error saying the item is not visible! The user forme is names = UserDataInputForm. The tab pages I have are
1st = InputDailyTimesPage 2nd = OverTimePage 3rd = DataPage 4th = DefultDataPage the form opens using the 1st tab page by default in the user forms inisilisation code I have this check
I have created a spreadsheet which serves as a reporting portal - if you select a product from a drop down, the spreadsheet automatically updates with data regarding that specific product. I would like to give my worksheet the ability to select a new item from the dropdown (that part i can do) and then print each of these product reports (1 page each) and aggregate them into one large pdf.
I have a formula that checks the previous page(Tab) for a figure so the formula goes =SUM(F37-'05-27-2007 thru 06-02-2007'!F37). Is there a way to instead of asking for the page '05-27-2007 thru 06-02-2007' to have it generically ask for the previous page?
I have a long growing statistical report(18 pages + more), and 14 of the pages will use report table headers. I went into the page set up and selected the row to repeat on each page. I do not want the table headers on any pages after 14. The rest of the report is formatted differently and does not use the row headers. but all of the information is related. Is there a way to only show the row headers up to page 14? I can't use headers and footers, of course. The report will be set in one place and the user will print it out once a week. It seems as if this cannot be done but I this is my last resort.