Find all dates; copy next cell to new cell.

AndyW · Apr 30th, 2002, 10:45 AM

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?

Tom Schreiner · Apr 30th, 2002, 11:01 AM

Sure.
There are probably several ways to accomplish this.
I only know one and am bored. Send me the work book and a sample of how you would like the summary to look.
TsTom@HotMail.Com
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 10:45 AM	#1
AndyW New Member Join Date: Jan 2002 Location: Western Australia Posts: 4	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?

Apr 30th, 2002, 11:01 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Sure. There are probably several ways to accomplish this. I only know one and am bored. Send me the work book and a sample of how you would like the summary to look. TsTom@HotMail.Com Tom