copy data from various sheets into one sheet
 

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?

copy data from various sheets into one sheet
 

I bet something here would help you

http://www.rondebruin.nl/copy3.htm

"vik" wrote in message
oups.com...
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?

copy data from various sheets into one sheet
 

Barb posted a link for workbooks

This one is for worksheets
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Barb Reinhardt" wrote in message ...
I bet something here would help you

http://www.rondebruin.nl/copy3.htm

"vik" wrote in message oups.com...
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?