Hi Ellymoo,

Seems a bit back the front to me.

You don't link data from multiple sheets into one datasheet. That's a
waste of time. You initially collect all of your data into one
datasheet or multiple datasheets and then analyse & report from that
source.

All data which shares common fields is collected into one datasheet,
with headings for each column (field). That is one table. You may
have multiple tables in which case you may want multiple datasheets.

When you have all of your data in structured datasheets like this,
reporting is greatly simplified. Excel has a multitude of tools for
analysing and reporting data when the data is stored in this datasheet
format.

I suspect a lot of your complex formulae may disappear with sound
structuring and reporting methods.

You should never - never - have to re-enter data on separate sheets.
That is bad practice.

So the short answer is to initially collect your data in the datasheet
rather than trying to link or move it there later.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532195

Thanks very much for your reply.

I work for a company with various bases. This workbook is their training
record, so they hop on and look at the sheet showing their base only, and
none of the others, hence it is separate. However, assuming that the best
way to go about it is work from the main sheet and allow the separate sheets
to update automatically when I enter data into the main sheet, how could I
'rejig' the whole workbook? Are there formulae I should use?

"John James" wrote:


Hi Ellymoo,

Seems a bit back the front to me.

You don't link data from multiple sheets into one datasheet. That's a
waste of time. You initially collect all of your data into one
datasheet or multiple datasheets and then analyse & report from that
source.

All data which shares common fields is collected into one datasheet,
with headings for each column (field). That is one table. You may
have multiple tables in which case you may want multiple datasheets.

When you have all of your data in structured datasheets like this,
reporting is greatly simplified. Excel has a multitude of tools for
analysing and reporting data when the data is stored in this datasheet
format.

I suspect a lot of your complex formulae may disappear with sound
structuring and reporting methods.

You should never - never - have to re-enter data on separate sheets.
That is bad practice.

So the short answer is to initially collect your data in the datasheet
rather than trying to link or move it there later.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532195

You may want to look into pivot tables. When structured properly you can use
the 'base' as a page field (essentially a filter) so that the users can
choose their base from a list and the pivot table updates automatically.

See Debra Dallgliesh's site for pivot table guidance

http://www.contextures.com/tiptech.html



"Ellymoo" wrote:

Thanks very much for your reply.

I work for a company with various bases. This workbook is their training
record, so they hop on and look at the sheet showing their base only, and
none of the others, hence it is separate. However, assuming that the best
way to go about it is work from the main sheet and allow the separate sheets
to update automatically when I enter data into the main sheet, how could I
'rejig' the whole workbook? Are there formulae I should use?

"John James" wrote:


Hi Ellymoo,

Seems a bit back the front to me.

You don't link data from multiple sheets into one datasheet. That's a
waste of time. You initially collect all of your data into one
datasheet or multiple datasheets and then analyse & report from that
source.

All data which shares common fields is collected into one datasheet,
with headings for each column (field). That is one table. You may
have multiple tables in which case you may want multiple datasheets.

When you have all of your data in structured datasheets like this,
reporting is greatly simplified. Excel has a multitude of tools for
analysing and reporting data when the data is stored in this datasheet
format.

I suspect a lot of your complex formulae may disappear with sound
structuring and reporting methods.

You should never - never - have to re-enter data on separate sheets.
That is bad practice.

So the short answer is to initially collect your data in the datasheet
rather than trying to link or move it there later.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532195