D
Darcy
I am trying to summarize some data from multiple worksheets
A1 A2 A3
B1 B2 B3
C1 C2 C3
D1 D2 D3
Basically at the bottom of each worksheet, i want to have something along
this line:
If A1 = True, then print A2, A3
If A1 = False, then go to next line
Continue until line is blank
Data in Column 1 is only True/False. The information I am collecting is
captured in Column 2 & 3.
I have tried using If, Then statements, which work but needs to be done
manually for each line, and each worksheet.
To complicate it, I have 33 worksheets, and I want to have 1 main summary
worksheet which collects all the data from each individual sheet.
Any ideas, my brain is hurting from this teaser today!?!
A1 A2 A3
B1 B2 B3
C1 C2 C3
D1 D2 D3
Basically at the bottom of each worksheet, i want to have something along
this line:
If A1 = True, then print A2, A3
If A1 = False, then go to next line
Continue until line is blank
Data in Column 1 is only True/False. The information I am collecting is
captured in Column 2 & 3.
I have tried using If, Then statements, which work but needs to be done
manually for each line, and each worksheet.
To complicate it, I have 33 worksheets, and I want to have 1 main summary
worksheet which collects all the data from each individual sheet.
Any ideas, my brain is hurting from this teaser today!?!