PDA

View Full Version : Search for specific text in multiple sheets and copy next line



rtlane
07-13-2017, 10:04 AM
Hi,
Im a newbie with excel, so bear with me.
I have an excel workbook with a lot of sheets (around 600). I have 1 main sheet which lists all the sheet titles in one column. All the other sheets have the data I need to pull into the main sheet. So per the example below....I want to match the sheet title with the corresponding sheet then fill in the egress rate and the type. So during the search it will find Site 1 sheet then search for the name "port 1/2/8" and then copy the next line and put it into the "type" column for Site 1. I then need to take the egress rate number that immediately comes after that and put it into the "Egress Rate" Column. I dont care if its by formula or vba. Any help would be greatly appreciated.
Example:
Main Sheet:
Sheet titles | Egress Rate|Type|
--------------------------------
Site 1
Site 2
Site 3
Site 4
Site 5

Site 1 Sheet:
Port 1/2/8
MW-1233....................
*********xx
*********xx
*********xx
*********xx
egress rate: 123456

p45cal
07-13-2017, 03:48 PM
In the attached a worksheet function you use as follows:
19735

rtlane
07-13-2017, 04:39 PM
In the attached a worksheet function you use as follows:
19735

Thank you