Help please with spread sheet dates

[John C]

I have a excel spread sheet as below and I would like to automatically copy the purchases column, to the in stock column using the date due in, at the moment I am just copy and pasting is it possible to automate this.

Thanks in advance.

John



Stock/Arriving soon
Model Reg Colour SIV Inc Del

Purchases Due in In Stock

Polo 1.0 E 3 Dr X914 YMV Silver £4,100.00 26-Oct-03
Polo 1.0 E 3 Dr X131 LCY Silver £4,260.00 30-Oct-03
Polo 1.0 E 5 Dr X463 WFX Silver £4,525.00 21-Oct-03 £4,525.00
Polo 1.0 E 5 Dr X714 WRB Silver £4,325.00 21-Oct-03 £4,325.00
Polo 1.0 E 5 Dr X251 NRS Indigo Blue £4,565.00 19-Oct-03 £4,565.00
Polo 1.0 E 5 Dr X381 OCK Silver £4,350.00 19-Oct-03 £4,350.00
Polo 1.0 E 5 Dr X364 WAA Black Met £4,375.00 19-Oct-03 £4,375.00
Polo 1.0E 5 Dr X382 ABU Mecarto £4,465.00 19-Oct-03 £4,465.00
Polo 1.0 E 5 Dr X391 UAY Mecarto Blue £4,325.00 19-Oct-03 £4,325.00
Polo 1.4 S 5 Dr X806 BDK Silver £5,310.00 27-Oct-03 £5,310.00
Polo 1.4 S X874 WAA Indigo Blue £5,325.00 19-Oct-03 £5,325.00
Polo 1.4 S X931 BAN Indigo Blue £5,185.00 19-Oct-03 £5,185.00
Polo 1.4 S Auto X348 JOJ Mecarto Blue £5,600.00 23-Oct-03
Polo 1.4 S Auto X349 ACB Silver £5,360.00 03-Nov-03
Polo 1.4 S Auto X119 HLC Indigo Blue £5,385.00 19-Oct-03 £5,385.00
Polo 1.4 Match 3 Dr X874 ELK Black met £5,000.00 19-Oct-03 £5,000.00
Polo 1.4 SE X61 HLC Silver £5,550.00 19-Oct-03 £5,550.00
Polo 1.4 SE X76 ABA Silver £5,965.00 19-Oct-03 £5,965.00
Polo 1.4 SE X403 DDJ Diamond Black £5,750.00 19-Oct-03 £5,750.00
Polo 1.4 SE Auto X654 EUR Silver £5,940.00 30-Oct-03
Polo 1.4 SE Auto W597 PCD Diamond Black £6,075.00 19-Oct-03 £6,075.00
Jeep 4.0 N Green £5,000.00 19-Oct-03 £5,000.00



Total £110,735.00 £85,475.00

 

[DavidP]

John

Your data is a little unclear. I have assumed that you have the data
in individual columns with the value in Col D and the date in Col E.
If this is correct then the following formula should work.

=IF(E1<=TODAY(),D1,0)

However I obtained a value of £80,165 as my calc did not include
X806BDK. which has a date of 27th October but you have valued. Is
this a mistake on your behalf or am I misunderstanding

David P
(e-mail address removed)

 

[Don Guillett]

Please don't post files or large messages.

I had trouble copying the spread sheet to outlook express, I did not want
to do an attachment as I thought no one would have opened it, the formula
worked after I changed the E1 and D1, will this now automatically copy the
details in column F to Column I once the date is passed.

I have attached the spread sheet.

Many thanks

John



copy the purchases column, to the in stock column using the date due in, at
the moment I am just copy and pasting is it possible to automate this.

 

[John C]

Don

Any idea how I can show my small spread sheet, as I seem to be having
trouble copy and pasting it.

John

 

[Jim]

An statement of the problem in your own words should do for most people.