Macro to selects data from several cells and place onto another WS

Hi,

I use a macro to copy data from fields on a sheet, and place that data into another sheet formatted for printing out. I specify which sets of data are to be selected by putting "L" in adjacent column AE.

It works great on my single sheet, BUT I now need it to function with several worksheets, ie. Search through the collumn in each WS, and if 'L' is present then get the data and put it onto the printout sheet.

Many thanks in advance.

Sample in attached SS.
This is my existing macro:

Formula:

Please Login or Register  to view this content.

This will loop through all the sheet on Locations, but I don't think it's giving the results you want.

You didn't provide a finished Template(or comment your code), so I couldn't tell what information you are wanting.

Please Login or Register  to view this content.