LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding columns automatically dave glynn Excel Discussion (Misc queries) 2 February 1st 05 06:36 PM
hiding columns automatically dave glynn Excel Discussion (Misc queries) 0 February 1st 05 06:15 PM
making columns automatically turn numbers into negatives Kathy Excel Worksheet Functions 6 February 1st 05 05:23 AM
Automatically enter date and time but only update once. PM New Users to Excel 3 January 21st 05 07:47 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"