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
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