471,855 Members | 1,043 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,855 software developers and data experts.

vb programming in excel copy paste problem

i need to make a report using excel. im given a few data in excel document for a 1 month report (1 document for each week). each data document have a few work sheet.i need only certain information in each week data. before this i do it manually by copy-paste each information i want to a new excel where i compile all the data for the month.i want to do some automation process.the problem is i dont have any idea on how to do that. can you all help me?

my question:
how open a certain excel document?
how do i copy only certain data in that document?
how do i arrange it and paste it accordingly in a new excel document?

thanks in advance for your help
Sep 10 '07 #1
0 1412

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Faith | last post: by
3 posts views Thread by Otie | last post: by
reply views Thread by Bob | last post: by
1 post views Thread by ʹÃûÑï | last post: by
3 posts views Thread by | last post: by
3 posts views Thread by Esmael | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.