LotHTML!A1 starts the formula and LotHTML!A4 ends the formula. In between, LotCards!A2 counts up to LotCards!A11, LotHTML!A2 is always to the left of LotCards! (except at the start), and LotHTML!A3 is always to the right.Please Login or Register to view this content.
I'm referencing 10 items in LotCards!A2-A11, but what I'd like to do is to be able to reference more or less than 10 items without having to manually add or subtract from the code each time.
There will be alot more columns to reference (LotCards!B2-CF2), all with a different number of items.
This is a tough one to explain, so I hope I made it clear enough. Thanks in advance.
Bookmarks