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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Data from Summary Sheet 5
Automatically update excel worksheet formula 7
Excel Count If Formula Question 1
Importing numbers from 200 worksheets into 1 4
Summarise data from several worksheets in a workbook 2
VBA Link - Previous post unclear 9
Help to create a macro 2
extract data from multple worksheets to a summary worksheet 2

Back
Top