URGENT! Please help

[gareth71]

I have two spreadsheets that have stock information for two departments, "Goods in" and "QC".

I am trying to update the "QC" sheet automatically from the "Goods in" sheet.

When a date is inserted into the "Goods in" sheet (column w) the "part no (j)", "quantity (k)" and "date released (w)" must be copied over to columns "partcode (b)", "date released from goods in (c)" and "qty delieverd (h)" in the QC sheet.

Goods in sheet:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]J[/TD]
[TD]K[/TD]
[TD]w[/TD]
[/TR]
[TR]
[TD]Part No[/TD]
[TD]Quantity[/TD]
[TD]Date released to QC[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]300[/TD]
[TD]28/03/2014[/TD]
[/TR]
</tbody>[/TABLE]
QC Sheet:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]b[/TD]
[TD]c[/TD]
[TD]h[/TD]
[/TR]
[TR]
[TD]Part code[/TD]
[TD]Date released from goods in[/TD]
[TD]Qty delivered[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]28/03/2014[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]
How do i do this or how can this be accomplished, I have no experience in VBA or macros and I need this today.

Thanks for any help.

Gareth

 

[Mel Smith]

Hello Gareth,

In cell B2 (Part code cell) type = and then select the relevant cell from your "Goods in" sheet e.g. J2 and then press Enter. Repeat for the other cells as required.

HTH

Mel

 

[gareth71]

Hi Mel,
Thanks for the reply, however the cells in the QC can only be populated when the "date released to qc (w)" cell is populated, the formula must also take into consideration any subsequent rows that are added to the goods in sheet, as these rows will also need to be added to the QC sheet as well.

Thanks
Gareth