copy from one sheet to another workbook

M

Marilyn

Hello I receive a weekly report from 144 people. I have to create a master
report.
Row 1 has the headings the information starts in row 2.
Using VBA how do I copy all the information starting with row 2 that have
a Yes in column A and paste the information in another workbook. Each
report has the same number of columns but not the same number of rows. I
created a simple macro to copy and paste but it is not very useful. since
the number of rows is never the same Thanks in advance
 

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

Merge Multiple workbook sheets into one workbook 0
Excel Help to copy information from one row at a time to another sheet 1
How copy automatically from one sheet to another. 4
Copy from one workbook to another 1
collect data from one excel sheet to another 3
Copy and Paste from one sheet to another 3
copying one sheet to another workbook 3
Move/Copy sheet to another workbook error 2

Top