PC Review


Reply
Thread Tools Rate Thread

How do i copy a sheet from one workbook to another using VB

 
 
DavidH
Guest
Posts: n/a
 
      23rd Jun 2008
i have a workbook that i keep data from an exported spreadsheet named Export
The sheet i copy to is name BillingData.

i have been manually coping the data and over writing the old data, then i
just manually look at it an any data that has changed, i highlight it "yellow"

well this was OK when it was only 40 lines, but now i have to do it for 5K
lines. so i need to figure a VB code that will import it and check it for
changes. This seemed simple at first but is now way over my head.

Are there any suggestions on how i can do this.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Copy sheet cells into differnt workbook/sheet, How? Shane Devenshire Microsoft Excel Misc 1 2nd Jun 2009 11:16 PM
Copy sheet cells into differnt workbook/sheet, How? IVLUTA Microsoft Excel Misc 0 2nd Jun 2009 10:56 PM
Copy rows from multiple workbook into a different workbook (sheet) Yossy Microsoft Excel Programming 19 11th May 2008 12:34 AM
Copy Range to a New WorkBook + Name Sheet a cell Value + Name WorkBook another Celll Value Corey Microsoft Excel Programming 2 2nd Nov 2006 05:01 AM
copy a sheet to a sheet within another workbook - WITHOUT buttons from the first shee equex Microsoft Excel New Users 0 21st Feb 2006 02:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 AM.