Move/Link Cell

[ggriffis]

I have a spreadsheet, with several worksheets, to keep track of my local IP Addresses and the associated workstation, printer, etc. What I would like to do is link the data from Worksheet1 to Worksheet2 if, and only if, column F contains the character "C". If column F contains "P", then link to worksheet 3, etc. This would allow me to have one worksheet with all of my IP (Worksheet 1) and another worksheet that only contains computers ("C"), etc.

 

[gingerafro]

How many worksheets do you have?
An IF formula will only allow 7 nestings.
A macro to sort the data may be better...

 

[ggriffis]

Ill have 6 total worksheets. Worksheet 1 and 2 will list the IPS (2 subnets). Worksheet 4-6 will be for the specific devices. I can create a sort macro, but I wanted someone to be able to click on the 'Workstation' tab and see a list of all workstations and the associated IP, same for printers and other equipment.