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!!!

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!!!