macro creates new sheet with data from other sheets

[jdcns]

Hi Everyone,

Could really use the help/pointers on an issue I'm having major difficulty with. This is my first post and I believe I'm a little over my head. The premise for my problem is easy enough: I have 4 tabs that are created via SQL (could be more or less than 4 tabs, depending on the customer) and I need a macro that generates a new tab and fills it in with aggregate data from the other sheets.

Attached is my file with a sample of data and the hypothetical template created. My main issues are:

- How do I make the macro move from one sheet to the next one once it recognizes the row is blank?
- On the template, I need to have the rows for the varieties numbered (Column A), but I cannot figure out how do to it as such.
- The 4th tab name begins with "expired". I need the macro to disregard these sheets (there can be more than one, but they're always at the end of the workbook).

This is my first foray into VBA and when given the task it seemed easy enough. I had taken a little bit of Java/C++ in college and was fairly good at excel basics, but I have no idea how to approach.

Any help or guidance, believe me, is GREATLY appreciated.

[jdcns]

anyone able to lend a hand?

[protonLeah]

Please note that I had to reformat your data/fruit sheets in order to make my macro easier....

[jdcns]

Thank you so much! This works really well. Appreciate the time and work you put into it.

My final question is: The values for column A on your macro-created report sheet are a series of numbers starting at 1.

Please Login or Register  to view this content.

How would you go about resetting the count once there is a new fruit listed in column B as I listed in my original sheet?

Either way, THANK YOU! THANK YOU SO MUCH!!

[protonLeah]

Please replace the single line:

Please Login or Register  to view this content.

With;

Please Login or Register  to view this content.

[jdcns]

i cannot thank you enough for the help. have a great weekend!