andytpl
09-04-2007, 06:56 PM
I have worksheet that summarises the outstanding actions from a series of worksheet with name as R1, R2 R3...
I have a macro that pull in the specific data from these worksheets. At the present moment the worksheet name, the data from Cell B8 and the data starting from Row55 Col B onwards are displayed. There is a condition set that if column 14 is empty data from Row55 Col B will be displayed.
What I would like to do now is the same condition but also apply to worksheet name and data from cell B8. That is to say if the condition is met display the data if not blank.
As this is beyond me I hope to get some help to solve this from this forum. A sample file is attached I hope will give more clarity to what I am requesting
Thanks
I have a macro that pull in the specific data from these worksheets. At the present moment the worksheet name, the data from Cell B8 and the data starting from Row55 Col B onwards are displayed. There is a condition set that if column 14 is empty data from Row55 Col B will be displayed.
What I would like to do now is the same condition but also apply to worksheet name and data from cell B8. That is to say if the condition is met display the data if not blank.
As this is beyond me I hope to get some help to solve this from this forum. A sample file is attached I hope will give more clarity to what I am requesting
Thanks