A
AliH
I have alot of worksheets that I would like to create a summary sheet for.
The summary sheet will have the following info
Worksheet Name in one column and the value from Cell G24 in the next column
Eg
Worksheet ABC1 Value G24 = £100
Worksheet CDE2 Value G24 = £150
Summary Sheet will look like
ABC1 £100
CDE2 £150
Is it possible to do this through code or do I have to manually go into each
individual sheet?
Thanks
The summary sheet will have the following info
Worksheet Name in one column and the value from Cell G24 in the next column
Eg
Worksheet ABC1 Value G24 = £100
Worksheet CDE2 Value G24 = £150
Summary Sheet will look like
ABC1 £100
CDE2 £150
Is it possible to do this through code or do I have to manually go into each
individual sheet?
Thanks