lostin_space
09-01-2006, 06:10 AM
Hi all, i've got a bit of an issue going on with copying data from multiple named ranges across to a 'roll-up' style / plain table style worksheet.
Here's what i'm doing - to collect entered data, I've created a worksheet in a 'data entry form' style format for my users... (each of the 'data entry' fields, btw is a unique named range) I need to copy across the data from each of the named ranges to a 2nd sheet in my workbook, and present it in a simple table / plain text table...
Sample sheet attached...
can anyone point me in the direction of a KB answer for this, or give me an idea of how to do this??
:banghead:
TIA
Russ
Here's what i'm doing - to collect entered data, I've created a worksheet in a 'data entry form' style format for my users... (each of the 'data entry' fields, btw is a unique named range) I need to copy across the data from each of the named ranges to a 2nd sheet in my workbook, and present it in a simple table / plain text table...
Sample sheet attached...
can anyone point me in the direction of a KB answer for this, or give me an idea of how to do this??
:banghead:
TIA
Russ