I hope I ask this correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel question which I hope I explain clearly. I have a worksheet that has the first line as headings and then a ton of data. The data will se sorted by column A and then column B (column A contains building codes and column B is the floor number). Anyway, is there a way to "parse" the worksheet so that all the individual building codes (and all related data) plus the headings are copied/pasted into a separate worksheet within the same spreadsheet? So, if I have 50 different building codes I would like to result to be 50 separate worksheets in the spreadsheet each containing a specific building code with its data (plus the heading).

Does that make sense?

Thanks very much.
 
Yes this makes sense!

what you need to do is record a macro where you use
filters, this way you can create the individual sheets
with, the headers.

what you need to do:-

1) start recording macro

2) set data- filters- auto filter

3) select a value from column A for your filter

4) select all - copy

5) create new page - rename "same name as filter value"

6) paste all data into new page

7) select initial page - take data- filter- auto filter OFF

8) stop recording macro

now you will see how the macro is used you can ask
specific questions for any areas not understood, but we
can modify it from there!

Robert Couchman
([email protected])
 
Robert,

Thank you very much for yuor thoughts. I figured that this method (macro) was going to be the solution. Now, to tweak your instructions:

What modifications need to be made to the macro so that this process takes place for every value I have in my filter? Right now I believe the macro works for individually selected values in the filter. Can the macro be re-written such that it will automatically perform this process for each value in the filter?

Once again, thank you for your assistance.

Mark
 
Can't tell you how to change a macro if we can't see it.

--
Regards,
Tom Ogilvy

Mark said:
Robert,

Thank you very much for yuor thoughts. I figured that this method (macro)
Click to expand...
was going to be the solution. Now, to tweak your instructions:
What modifications need to be made to the macro so that this process takes
Click to expand...
place for every value I have in my filter? Right now I believe the macro
works for individually selected values in the filter. Can the macro be
re-written such that it will automatically perform this process for each
value in the filter?
 
Back
Top