Hi all,
I'm trying to wrap my mind around the best way to do this. I'm using Excel 07.
I have a tab that has a UPC listing if you will, it list the product and the package.
Secondly I have a tab that has pricing info on it, one package per row, I want to be able to copy all the UPC's that are associated with that package (ie flavors of that package).
So in short I have the UPC list with the UPC's listed vertically and I'm trying to copy the UPC's to a row. Any idea's on how to make this work?
I found via searching this formula INDIRECT(ADDRESS(COLUMN()-3,1)) but my UPC's are on a different tab so that doesn't exactly work...
Any thoughts or idea's? As always thanks for your help!
I'm trying to wrap my mind around the best way to do this. I'm using Excel 07.
I have a tab that has a UPC listing if you will, it list the product and the package.
Secondly I have a tab that has pricing info on it, one package per row, I want to be able to copy all the UPC's that are associated with that package (ie flavors of that package).
So in short I have the UPC list with the UPC's listed vertically and I'm trying to copy the UPC's to a row. Any idea's on how to make this work?
I found via searching this formula INDIRECT(ADDRESS(COLUMN()-3,1)) but my UPC's are on a different tab so that doesn't exactly work...
Any thoughts or idea's? As always thanks for your help!