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.

I have provided an example at http://www.HelpExcel.com/examples.
The name of the spreadsheet is moveData.xls
--
http://HelpExcel.com




"lob" wrote:

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 wrote:
I have provided an example at http://www.HelpExcel.com/examples.
The name of the spreadsheet is moveData.xls
--
http://HelpExcel.com




"lob" wrote:

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.

I provided an example of what you are looking to do in Excel. You just need
to go to folder specified and download the file I placed there.
--
http://HelpExcel.com




"lob" wrote:

Thanks very much for the reply.
I am not really sure how this works, could you please provide a brief
explanation.
galimi wrote:
I have provided an example at http://www.HelpExcel.com/examples.
The name of the spreadsheet is moveData.xls
--
http://HelpExcel.com




"lob" wrote:

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.

galimi

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

ApplicationCutCopyMode = False

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


Gord Dibben MS Excel MVP

On Thu, 18 Jan 2007 12:10:01 -0800, galimi wrote:

I provided an example of what you are looking to do in Excel. You just need
to go to folder specified and download the file I placed there.

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.

On Jan 18, 2:00 pm, Gord Dibben <gorddibbATshawDOTca wrote:
galimi

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

ApplicationCutCopyMode = False

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

Gord Dibben MS Excel MVP



On Thu, 18 Jan 2007 12:10:01 -0800, galimi wrote:
I provided an example of what you are looking to do in Excel. You just need
to go to folder specified and download the file I placed there.- Hide quoted text -- Show quoted text -