Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy from one sheet to another workbook
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet to different workbook | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) |