Summary worksheet question

  • Thread starter Thread starter lob
  • Start date Start date
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.
 
Thanks very much for the reply.
I am not really sure how this works, could you please provide a brief
explanation.
 
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
 
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.
 
Back
Top