Summary worksheet question

L

lob

I have a file with a number of worksheets that are identical but have
different conditional formatting criteria, these we will call 'data
sheets'. I would like all the data from row 3 downwards in all the
'data sheets' to be listed in the 'summary worksheet' in this
file. I will need the 'summary worksheet' to be updated
automatically when data is entered in the 'data sheets'. How can
this be accomplished? Thank you for your help.
 
L

lob

Thanks very much for the reply.
I am not really sure how this works, could you please provide a brief
explanation.
 
G

Gord Dibben

galimi

Your examples would make more sense if you completed the code with

Application>CutCopyMode = False

Otherwise users are left with a set of "marching ants" to deal with.


Gord Dibben MS Excel MVP
 
L

lob

Hello again
I am a basic excel user and do not know how to use macros, which I
understand this is, thanks for your efforts.
 
Top