Hello I'm new in the forum.
I have a problem with a workbook how to create some reports.
I had post my question to another vba- forum but no answer to fit me!!!!
SO I please for your help.
I have a workbook with more than 12 sheets. Sheet names are month of a year. The months starts from September until next August. The sheets names are like 09_14, 10_14 .... 08_15
In every month sheet i have the same template. Col A is numbering from A3 to ....., col B is the names, col C is value 1, col D is value 2, col E is value 3, col f is value 4, col G is remarkA, col H is remark B.
What I want is 3 types of reports:
1. Search between months (start - end) for a specific name (col. B), and the result (col B until col H) should go to a sheet named report.
2. In every sheet some names have a specific remark col G-H. The remarks are "AA" or "BB". Search for all AA or BB between months (start - end) and the result (col B until col H) should go to a sheet named report.
3. I have a sheet Year. That sheets add every month some sums (col C-F) of every month sheet. I want to Search between months (start - end) and the result (month sum Col C-F) should go to a sheet named report.
I appreciate for every help.
Maybe i can provide an attach file??
Thanks a lot for your time
I have a problem with a workbook how to create some reports.
I had post my question to another vba- forum but no answer to fit me!!!!
SO I please for your help.
I have a workbook with more than 12 sheets. Sheet names are month of a year. The months starts from September until next August. The sheets names are like 09_14, 10_14 .... 08_15
In every month sheet i have the same template. Col A is numbering from A3 to ....., col B is the names, col C is value 1, col D is value 2, col E is value 3, col f is value 4, col G is remarkA, col H is remark B.
What I want is 3 types of reports:
1. Search between months (start - end) for a specific name (col. B), and the result (col B until col H) should go to a sheet named report.
2. In every sheet some names have a specific remark col G-H. The remarks are "AA" or "BB". Search for all AA or BB between months (start - end) and the result (col B until col H) should go to a sheet named report.
3. I have a sheet Year. That sheets add every month some sums (col C-F) of every month sheet. I want to Search between months (start - end) and the result (month sum Col C-F) should go to a sheet named report.
I appreciate for every help.
Maybe i can provide an attach file??
Thanks a lot for your time