I am trying to manipulate the information....

ie.. If Delivery date is equal to "*" and Item Code is equal to "*" then
enter the Delivery Qty from this line to this cell...

It is quite complex for me and I have had a bit of help..

Without showing the actual spreadsheet, it is difficult to describe..

"bigwheel" wrote:

I'm not quite sure what your'e trying to do here, (the formula doesn't help)
are you trying to manipulate the data from Sheet A or just copy it?

"AJButler" wrote:

Hi there,
I don't know whether anyone can help me or not. However, if there are any
Excel experts out there, I am a little stuck.

I download some information from an Access into Sheet A.
I then have to pull the information from Sheet A into Sheet B using the
following formula

=SUMIF('Sheet A'!$E:$E,CONCATENATE($B3,"$",D$2),'Sheet A'!$D:$D)

This does not enter the information into Sheet B until you go back into the
cell in Sheet A and press F2 to edit and then press Enter.

Is there a way of preventing this?

If not, how can I produce a macro to allow me to automatically. When I
record one it comes up with this:

Range("D2").Select
ActiveCell.FormulaR1C1 = "44160"
Range("D3").Select
ActiveCell.FormulaR1C1 = "21600"
Range("D4").Select

I would appreciate some assistance if possible...

Cheers
AJ