- Joined
- May 17, 2005
- Messages
- 105
- Reaction score
- 0
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
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