Evening all,
I have a sheet with alternating columns of dates and $ values; five of each; the first three columns of the sheet are static inputs; the alternating columns start after these.
The date value is input manually to record the date the $ value had been claimed; the $ value remains static, only the dates are entered as needed.
I need to:
Find each date; know what claims were made for each date; copy the data (dates & $ values) to a new 'report' sheet for analysis.
Any ideas?
I have a sheet with alternating columns of dates and $ values; five of each; the first three columns of the sheet are static inputs; the alternating columns start after these.
The date value is input manually to record the date the $ value had been claimed; the $ value remains static, only the dates are entered as needed.
I need to:
Find each date; know what claims were made for each date; copy the data (dates & $ values) to a new 'report' sheet for analysis.
Any ideas?