copy data from various sheets into one sheet

V

vik

hi everyone, i need some help with a macro, not sure where to start:

I am trying to write a macro which will pull data from different sheets
in an excel file, if i chose that sheet to be selected (via a 1 or 0)
and copy that data and paste the data into a new sheet.

all data is in columns A & B of each sheet and runs to row 100.
Basically, if the sheet is selected with a 1, then i'd want the macro
to go to that sheet, copy the range: A1:B100, and then paste is to a
new sheet. I would want the results (of only the selected sheets) to
end up in columns A & B of the summary sheet...basically creating one
long set of data of only the sheets I selected via a 1 or 0 on the
summary sheet...

does that make sense?
 

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

how to copy and paste value from one sheet to another 4
Need Help with a VBA subroutine 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Combining two sheets of data into one and sorting by value - using macros 5
copy cell range in other sheet 1
Match and delete rows on two different sheets from reference numbers 4
Copying Portions of Data 0

Top