View Single Post
  #1   Report Post  
Eric D.
 
Posts: n/a
Default 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!!!