Hello Everyone!
This forum has been a lifesaver!
I have an issue that i cannot find the resolution anywhere, i am hoping someone here can help!
I have a spreadsheet that i am pulling data from another tab (='Retailers '!$C$3), on the "retailers" tab i have over 400 rows, and each row is a different retailer. On the sheet i am working on i want to pull that for each row but repeat 105 times. I have been filling and changing the row number manually, but if i have to do this over 400 times it will take forever, and i am sure there is an easy way to do this.
I am going to give a little example here in a small scale
TAB 1 (Source)
Walmart
Target
Lowes
TAB 2 (i will do repeat formula 2 times vs 105 to make it easy)
='TAB 1'!$A$1 (Walmart)
='TAB 1'!$A$1 (Walmart)
='TAB 1'!$A$2 (Target)
='TAB 1'!$A$2 (Target)
='TAB 1'!$A$3 (Lowes)
='TAB 1'!$A$3 (Lowes)
Not sure if i was clear, hope i was. Thank You in advance!
Bookmarks