Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

link data to worksheets

0 views
Skip to first unread message

john

unread,
Jan 8, 2008, 8:19:01 AM1/8/08
to
I'm tracking data for three products on a master sheet but want to link the
complete row/line item data to individual sheets for each product.

ryguy7272

unread,
Jan 8, 2008, 9:31:06 AM1/8/08
to
The more you explain the issue, the more help you will receive. I, for one,
don't know what you are referring to here. Please provide more info.

Regards,
Ryan--

--
RyGuy

john

unread,
Jan 8, 2008, 11:08:02 AM1/8/08
to
I have one workbook with 4 sheets labelled "Master" with Products 1,2 & 3
data being tracked,then sheets "Product 1" ,"Product 2", "Product 3". Data on
Master has info for all three but I want to link the line items to summarized
individually from Master sheet to individual sheets as I'm entrering the data
on Master sheet only.

ryguy7272

unread,
Jan 8, 2008, 11:55:02 AM1/8/08
to
Hummm, well, I think the most obvious answer is probably the correct
one...link the sheets with "=". Read this document for information:
http://thehub.clayton.edu/thehub/guides/excel-protect.pdf


Hope that helps. Post back if you need more info.


Regards,
Ryan--

--
RyGuy

john

unread,
Jan 8, 2008, 1:37:00 PM1/8/08
to
Ryan,
We're getting there, what I'm trying to do is similar but reverse. I want to
enter all data for 3 products on Master sheet and then have the data from
that sheet link to individual sheets based on Product 1 info on Master sheet
to Product 1 sheet , Product 2 on Master sheet to Product 2 sheet ...

I appreciate your input.

Thanks
John

ryguy7272

unread,
Jan 8, 2008, 2:57:03 PM1/8/08
to
Type the '=' on the keyboard and then click on the tab of the sheet that you
want to link to then click the specific cell on the sheet that you want to
link to.

Regards,
Ryan---


--
RyGuy

john

unread,
Jan 9, 2008, 9:21:00 AM1/9/08
to
I'll try explaining a different way:

Source Data/Master worksheet:

Item Date Ref # Issue Sent
back to

Product #1 Jan 10 Ser # 123 Bad Paint job ABC Paint
Product #3 Jan 9 Ser # 456 Metal is bent Metal Co
Product #2 Jan 12 Part #987 Wiring Malfuc Elect Co
Product #3 Jan 12 Part #998 Wiring shorted Elect Co

What I'm trying to do is have the Source Data worksheet/Master sheet
transfer/link
the ROW data based on ITEM or COLUMN #1 to individual worksheets Poduct #1,
then another sheet Product #2 ...

This way I can enter data on one sheet but be able to track/review issues
product by individual product

Any ideas would be greatly welcomed!!

Thanks
John

0 new messages