CK Nursery and Finish Inventories.xlsxAttachment 207447
I would like the "Finish Summary by Age" tab worksheet to look like the "Nursery Master Sheet" and "Circle K 1 - CD Farms Nursery" tab worksheets. I'd like the "Finish Summary by Age" tab worksheet to cover the majority of the paper like worksheets on the other tabs.
When I hit the print button the worksheet prints on the paper in the bin. However, there are times when I need to print the worksheet on different paper which requires me to go into the properties and change the paper source from Automatically Select to Manual Feed. I have been trying to created a macro what will switch to Manual Feed, print the worksheet and then switch back to Automatically Select but have been unsucessfull.
View 3 Replies View RelatedIs there an easy way to format cells so that they are square like graph paper?
View 2 Replies View RelatedI am trying to take the tables you will see in the dummy page on the second and third sheet and have them output onto the first sheet based on the parameters of the drop down menus. Is there a way to have a button on the first page that controls a macro to do this?
View 4 Replies View RelatedI have attached a workbook with various worksheets. the aim being to create a cover worksheet called "averages".
Every few days i will manually add a new worksheet in the same format as "332" i had to delete most of the data from "333" to meet the file size limit but you should still get the idea. I would like the "averages" worksheet to work out an average rating and pull the data for all competitors from all worksheets.
I All my data is obtained from 2 columns, USERS & rating which i manually copy paste to a new worksheet every few days from that info i build my basic pivot table. maybe i can gather all the USER & rating columns on the same page and use a more complicated pivot table and thus do away with all the worksheets completely? But I do like being able to easily compare each individual rating against the other competitors for that particular day.
Attached File : competitor ratings1.xls
I have a worksheet with 30,000 rows. But sometimes even if I have fewer records in this worksheet(lets say 1000) worksheet shows the same 30,000 rows.And its annoying when you try to navigate using vertical scroll bar. Is there any option to re-adjust the worksheet to make it more user friendly based on number of rows in current sheet.
View 2 Replies View Relatedhow to choose 11 x 17 paper as my paper size option. They don't want it on anything but this size.
View 8 Replies View RelatedI have one page in excel to print. But I want to print it 1000 times and on each paper i need another serial number. How do I do this?
View 4 Replies View RelatedHow do you print on paper a formula that is in one cell?
View 9 Replies View RelatedI have 2 colums that represent the height and width of a paper edges. And now I would like to find a formula (somekind of an IF?) which would calculate automatically (taking account the values in these colums) which of these 2 measures make together ISO paper sizes A0 (84,1x118,9), A1 (59,4x84,1), A2 (42,0x59,4), A3 (29,7x42).
View 2 Replies View RelatedWhat i need is someway of when ever these certain numbers:
75
85
87
95
are entered into any row on column 1, then are automatically blacked out and un readable untill the cell is changed to another number.
I am currently using a sheet of paper and tallying events. By tallying, I mean placing a small vertical line on the paper, then after 4 vertical lines, I place a diagonal line across the four. At the end of the month, I add all these up. I would like to make a spreadsheet to replace the tallying, but am not sure how to do it. Is this possible? I am beginner to intermediate with Excel and use 2003, but can switch to 2007.
View 3 Replies View RelatedI am need to setup an IF Function to cover several columns. I need the function to be able to look at Column A, B, C, and D and see if any are blank. If any of these is blank I need the function to give "Pending". If all of these columns have a Y then I need the function to give me "Completed".
View 9 Replies View RelatedI have a workbook that has a cover sheet which contains the names of all the tabs in the workbook. I need to be able to change the names in the cover sheet and the names in the tabs to be change to whatever the corresponding cell in the cover sheet text is.
View 14 Replies View RelatedIs there any way that this bit of code can be combined to create a shape using dates that fall on weekends (that are listed in row2) and at the same time cover all rows up to the last Row used in a worksheet?
For instance, in the columns of Row2 we have many dates and we would have "16-Jan-10" in one column and "17-Jan-10" in another column (usually the next column) which are weekend dates. the shape should be created in the next row under the weekend date and cover the column all the way down to the last used Row (last Row contaning data).
With ActiveSheet.Shapes.AddShape( _
Type:=msoShapeRectangle, _
Top:=.Top, Left:=.Left, _
Width:=.Width, _
Height:=.Height)
.Placement = xlFreeFloating '
.Fill.ForeColor _
.RGB = RGB(Red:=192, Green:=192, Blue:=192)
End With
Pretty straightforward: randomly and infrequently, Excel ignores my selection of the rear tray paper source on my MX870 Canon. Able to correct issue only by closing out and re-opening Excel.
View 1 Replies View RelatedI wanted to work backwards from a weeknumber (as defined in Excel). In other words, given a week number (i.e. 5) what is the first date and last date of that weeknumber. These are the formulas that I came up with and they work fine.
Formula: [Code] ......
Ffor 1st of the week and
Formula: [Code] .......
For the last of the week.
Attached File : Weeknumber.xlsx
this is normally a very simple thing to calculate and I know how to calculate for speed, distance and time or SoDiT as we learnt at school..
I have a period of time where a distance in feet is covered. Lets say 1 hour 25 minutes to cover 12,600 feet, just over two miles.
What I need to solve for in this case is not speed exactly, but how long it takes to cover 10 feet in this scenario.
I start to do the math in excel and then the formatting jumps when I set to hh:mm:ss and I get confused whether I'm multiplying or dividing by 60 and it all becomes a mess.
I have tried to make cartesian coordinates (X)and (Y) using excel 2007. now I want to represent some shapes (circles, squares, triangles, and so one). My problem now is with formating those shapes. I use this path (Insert > Shapes),, but the shape I add cover the grid,
I want (for example) a circle but I need only its circumference, and without covering the grid by its area. the same for other shapes.
I got a workbook with one active sheet. There are 6 colums and 55 rows. I want to creat a macro or formula to automatically print each individual row on a single sheet of paper. i will only need the line with a specific value printed i.e only print value more then 5
View 9 Replies View RelatedI have 36 pages of names, addresses & contact info ETC that I want to print. I have a printer that offers a cover sheet in the print setup.
My list of names addresses ETC takes up two full pages of paper for each name. There are 16 columns across the sheet that contain data for each entry. I would like to print this so that I can turn the pages like an address book and see all of the data for a given set of contacts on each two page spread. So what I need to do is print the first half of the contact info on the inside of the first page and the second half on the next page and so on.
How can I set this up?
I hold some data in the Excel 2007 file. It's about 400 rows and about 10 columns. On occasion I have to print some values from this file. But it has to be in defined position on the paper. It is like I already have the prepared paper with fields, and I just have to fill some fields on the paper with data from the columns. Is it possible to make a program that will take each row that I label for printing, and print just some columns but in a defined position on the paper ?
View 5 Replies View RelatedHowever I only put in a small price list when i tried extending it the workbook produced error as per attached. I thought i would just need to amend the row numbers but it doesnt seem to work
unable to upload at present but prevoius is available on this thread. http://www.excelforum.com/excel-work...hoice-sum.html. Need to extend price list to cover up to 10,000 lines
I have drawn up a simple summary to show what I am trying to achieve: ...
View 9 Replies View RelatedCalculate the weeks cover of current inventory based on a sales forecast. the forecast is in weekly buckets so I was thinking using some form of loop statement within the function which basically starts with the inventory figure then subtracts the forecast week by week until the inventory figure is less than the weekly forecast. I should then be able to divide the inventory by forecast and add back the number of loops to give me the weeks stock figure.
I have done this using if statements but it will only allow me to use 10 statements in the function and I need to do this for a full years worth of forecast.
Does anyone have a suggestion as This problem is becoming quite frustrating.
Here's an example of how the spreadsheet looks
Forecast103050205040Inventory 20019016011090400Weeks Cover6.05.04.03.02.01.0
I'm working on a project, and I need a cell on a worksheet to produce the name of the worksheet, such that if the worksheet changes, or is copied [Sheet1 renamed to Sheet(1), for example] the cell will automatically update [now displaying Sheet(1) in cell A1].
View 2 Replies View RelatedI need to make an identical copy with the name I choose from the input box with (wk2).
For example:
If I enter Tommy in the input box, it would make 2 worksheets:
Dim NewSheetName As String
Sheets("NewPerson").Copy After:=Worksheets(Worksheets.Count)
NewSheetName = InputBox("What would you like to name this sheet?")
On Error GoTo Err_Trap
ActiveWindow.ActiveSheet.Name = NewSheetName
Err_Trap:
If Err.Number = 1004 Then
Application.DisplayAlerts = False
Sheets("NewPerson (2)").Delete
Application.DisplayAlerts = True
MsgBox ("A new sheet was not created." & Chr(10) & _
"Please choose a different name."), vbInformation, "Sheet Creation Error"
Exit Sub
End If
I have a list A2...A11
In cell B1 is the following formula: =SUM(IF(FREQUENCY(IF($A$2:$A$11"",MATCH("~"&$A$2:$A$11&"",$A$2:$A$11&"",0)),Rvec),1))
Rvec is defined in NAME MANAGER as: =ROW(Sheet1!$A$2:$A$11)-ROW(Sheet1!$A$2)+1
In cells B2...B11 is this formula: =IF(ROWS($B$2:B2)
I'm trying to make two identical worksheets in a workbook. I would like the second sheet reflect all the changes made in the first one. I thought I would simply use = but it doesn't work correctly if I add or delete rows. If I add a row between row 1 and 2 in the first sheet the formula in row 2 in the second worksheet changes from =sheet1!A2 to =sheet1!A3. The result is the same if I use absolute references which suprised me. I want the formula in row 2 to stay =sheet1!A2 whatever happens on the first sheet.
I don't care about formatting, just data are important.
The reason I want the same data on two worksheets is that the second sheet will contain some more data that should not be visible to everyone. I want to protect the second worksheet and require a password to unhide it.
When creating a drop-down list using Validation, is there any way to make the source a different worksheet in the workbook? Right now when I click on Source and select my list, it will not allow me to go to another worksheet.
If I manually enter a reference to cells in another worksheet, such as 'PCP'!$A$2:$A$250 it only shows that cited reference, not the actual list.