Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a way to automatically add columns as the data updates?
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!!! |
#2
|
|||
|
|||
I think I should add, I'm wanting Sheet2 to look at Sheet1 A1, and when that
cell changes, or does not equal any of the values in Sheet2 row 1, then it adds the new information to Sheet2..... or did I just confuse things even more? "Eric D." wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |