Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I get sheet 2 to add columns as I finish with data in sheet 1? Hmm,
how to best explain this..... Sheet1 A is "this month's budget" with rows 1:50 . When this month ends, I want to take the "values" of Sheet1 a1:a50, and have them automatically go into the next blank column on sheet2, and be able to use Sheet1 A for THIS month, and so on, and so on..... did I explain this well enough? The EASY way is to just copy and paste special, values... but I want to do it the fancy, automated, modern way! Actually, I have several sheets that this would help with, and save me about 200 copy/pastes a week.... THANKS!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding columns automatically | Excel Discussion (Misc queries) | |||
hiding columns automatically | Excel Discussion (Misc queries) | |||
making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |