Linking cells on sheets after sorting

perpetual98 · Oct 6, 2004

Hi all. I've got a spreadheet that encompases several assemblies that we make. In the spreadsheet is my inventory level for each part, along with other information that I don't think is relevant for my question. I've added new sheets that contain the data for each assembly and their specific parts, instead of the first sheet which is all parts in inventory. It's easy enough to sort my first page by inventory (weeks supply basically), but is there a way to tie the count column on sheet 1 to the repective count columns in sheets 2, 3 etc? If they were in a static location, it would be easy, but my formula sorts by usage and weeks remaining of inventory, if that makes any sense. I can assign a column with an "ID" number for each part, but I'm new to programming formulas.

Thanks!
Eric

Tazguy37 · Oct 6, 2004

Sounds like what you want can be done, but it might be helpful if we could see a sample of you sheet(s). Have a look at Colo's HTML Maker utility to post your sheet.

perpetual98 · Oct 6, 2004

Zoinks, this is going to be a shot in the dark to see if it even works...

Parts breakdown.xls

A

B

C

D

E

F

G

H

I

1

pcs/

10/4

Total

Weeksusage

2

Description

Assembly

unit

PartNumber

Counts

OnOrder

Units

at60/wk

3

4

cover

Axial

Merbeth

2249740

0

0.00

5

Base

Axial

Merbeth

2345622

11

0.18

6

Drivesupports

Axial

Merbeth

2229623

37

19

0.31

7

Fuseblock

HEMRC

Bussman

2185277

80

1.33

8

Motor

Axial

AB

ABSP301908

53

0.88

9

Drivesurround

Axial

Merbeth

2249742

53

0.88

10

FDrive

Axial

AB

AB1336FBRF50ANEN90

76

1.27

11

harnessfor2217930-3

Axial

Excel

2390437

60

1.00

12

harness

Axial

Excel

2272980

63

1.05

13

sidecar

Axial

Merbeth

2249743

67

1.12

14

Bussman10Afuse

HEMRC

Bussman

BUSFWP10A14F

68

1.13

15

Brake

Axial

Inertia

2254392

96

1.60

16

PlasticCover

Axial

Dielectric

2260672

97

1.62

17

harness

Axial

Excel

2271058

98

1.63

18

filter

Both

Teledyne

2168593

221

111

1.84

All

Ok, that looks kinda ugly because of the spaces, but I think you can figure it out. That's just a part of my spreadsheet. Column F & H are what changes the sorting of the whole sheet. The different sheets are based on column B. Does that help at all? Probably not. Anyway, if I got in a bunch of parts and updated my spreadsheet, the total units may change and it would move that part lower on my sheet. I'd like to be able to update the first sheet and have it dynamically update the other sheets, even if the parts were in a different order on the first sheet. Does that make sense?

Eric

Tazguy37 · Oct 6, 2004

You can reference a cell in another sheet like so: =Sheet1!C8 will give you the value of cell C8 on Sheet1. Does that point you in the right direction?

perpetual98 · Oct 7, 2004

I knew how to do that, but the part numbers in sheet 1 aren't in static columns in relation to sheet 2. It's sorted by parts and weeks supply. If I receive a shipment of parts from my supplier, that part moves down the list.

Linking cells on sheets after sorting

perpetual98

New Member

Excel Facts

Tazguy37

MrExcel MVP

perpetual98

New Member

Tazguy37

MrExcel MVP

perpetual98

New Member

Similar threads

Forum statistics

Share this page

Linking cells on sheets after sorting

perpetual98

New Member

Excel Facts

Tazguy37

MrExcel MVP

perpetual98

New Member

Tazguy37

MrExcel MVP

perpetual98

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock