Copy data to master sheet, when >0

Closed
Genae Posts 2 Registration date Wednesday September 26, 2012 Status Member Last seen September 27, 2012 - Sep 26, 2012 at 05:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 2, 2012 at 09:55 AM
Hello,

Is there anyone who can help me with this? I cannot for the life of me figure this out and need this spreadsheet working asap for my boss. Please help!!

We have a workbook that contains 20+ sheets but only 4 pertain to the Master Material List. When the salesmen enter quantities of parts (column E) for a job on one of these 4 sheets I need that part (A4:G4) copied over to 'MATL LIST' starting at A5.

Data to automatically copy from cells A4:G4
'2 Voice Evac' (Sheet1)
'3 Faraday' (Sheet2)
'4 Sinorix' (Sheet3)
'5 Sig Bat' (Sheet4)

into 'MATL LIST' A5:F5 (Sheet5)

only when the value of cells in part of column E ('2 Voice Evac'E4:E53, '3 Faraday'E4:E56, '4 Sinorix'E4:E55, '5 Sig Bat'E4:E57) are greater than 0.

I've tried the Advanced Filter option, fiddled around with some macros I found online that were similar but can't get it to work and I don't know macros very well. Any help is MUCH APPRECIATED!!

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 2, 2012 at 09:55 AM
Hi Genae,

To avoid macro's you could use a column to input the following formula:
=IF(E4>0,"Yes","No")
Now filter on Yes and you can copy your data.

Best regards,
Trowa
0