Creating Master Worksheet that transfers data to other worksheets

[AliciaCNR]

I have a 4 worksheet excel file. All worksheets have the same information on them, but categorized differently. ie; one sheet is organized by name, one by number, one by expiration date, one by color. Each file has whatever data it is organized by in column A. I would like to have worksheet #1 be the master worksheet, and when I input a data change onto that sheet, it correctly transfers to all other sheets, though the info is in different columns.

Is this possible? Any tips would be greatly appreciated!

[FDibbins]

Hi and welcome to the forum

This sounds do-able, but it would help if you provided a small sample workbook, showing what you have, and what you want.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[AliciaCNR]

excel keys.xlsx

The first sheet is all the information, I would like the next 3 to contain the same info, but be organized by the column that the worksheet is titled. if information is changed on the first sheet, I would like it to reflect on all of them.

[FDibbins]

Is it necessary to have those headings between the different tables?

[AliciaCNR]

No, I suppose not

[Vikas_Gautam]

Got the solution...

Check the attachment...

Sorted by your reference...


Don't forget to click *

[FDibbins]

Vikas, maybe Im missing something? all 4 sheets are identical?

[FDibbins]

This is a bit messy, it used Pivot tables on each sheet, see if it something you can use?

[FDibbins]

I guess it would help if I actually attached the file huh?