Is there a way to automatically add columns as the data updates?

G

Guest

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

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cells to sheet2 based on selection in sheet1 0
Is there a way to copy cells with absolute reference gettingadjusted? 3
Half way there with "IFAND" 0
Copy non merged to merged cells again 1
Master sheet data HELP!(please) 6
Copy non merged to merged cells 2
Splitting data from one spreadsheet into multiple spreadsheets 2
Copy paste non merged to merged cells 1

Top