#1   Report Post  
Junior Member
 
Posts: 1
Question Help

So i recently got a job and am resposible for changing all the old excel spredsheets that we used the passed years and updating them for this year...i would like to use the same format because it is very well done but was wondering if theres a way i can just copy and paste the set up and formulas already in place without copying all the old data...if the is that would be Fantastic, if not ill will contiue doing them one by one, but it does take a long time cause i have over 1000 lines of data

any help or suggestions?
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Krissy24 View Post
So i recently got a job and am resposible for changing all the old excel spredsheets that we used the passed years and updating them for this year...i would like to use the same format because it is very well done but was wondering if theres a way i can just copy and paste the set up and formulas already in place without copying all the old data...if the is that would be Fantastic, if not ill will contiue doing them one by one, but it does take a long time cause i have over 1000 lines of data

any help or suggestions?
Very hard to answer that question without some idea of the workbook layout.
Would a sample be possible?
Reply
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



All times are GMT +1. The time now is 03:33 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"