I created a sheet with many Vlookups, left and right, and mathematical formulas. The formulas don’t change. People dump data into this sheet and the look ups do the rest. Because this is a weekly YTD exercise the number of rows changes all the time. You dump a new file each month and drag the formulas down for each column (9 in total). Is there a trick or macro that would do this automatically? I mean if I add a new item can the formulas be copied automatically.
Your help would be greatly appreciated.
Noah Navarro
Your help would be greatly appreciated.
Noah Navarro