| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coping a whole row to another sheet
What would be the best way to creat a command button (on sheet "Report") that
will pull (from sheet "Report Data") only the month (colum AI) in which is stated on sheet "Report" ActivCell F12. Insert the (whole row) results in a new sheet at the end of the workbook or existing sheet "Monthly Report". Then Hide colums D thru AE and AI, totaling Colums AF, AG and AH. Creating a formual in a cell that will take the total in AH to see if it is over the budget amount by dividing the annual budget number in sheet "Report" cell F10 by 12 then stating how much money is left for the year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for coping a cell from a diffent sheet | Excel Discussion (Misc queries) | |||
| WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY? | Excel Discussion (Misc queries) | |||
| Coping Contents of one Sheet into Another Workbook | Excel Programming | |||
| Questions on copying from one sheet to the other and coping every other cell. | Excel Discussion (Misc queries) | |||
| Coping a sheet | Excel Programming | |||
Threaded Mode
