Hi all.
Please could someone help make my life a little easier? I have a data source that I need to repackage into a table. Both the data source and the table are on separate tabs in the attached excel. The first table has formulas in it that guide it to the correct cell to get the data. However, I have multiple tables that need to be sequentially populated with the data in the next row in the data source (i.e. the first table contains A, B, C, etc; the second table contains A2, B2, C2, etc….). I tried to copy the formulas into the next table by dragging the bottom right corner of the first table, but instead of extracting the data from the next row in tab data source, it pulls data from 14 rows deeper (because 14 is the number of rows in the copied table). How would I fix this?
Thanks in advance, excel masters.
Bookmarks