Copy data to master sheet, when >0

[Closed]
Report
Posts
2
Registration date
Wednesday September 26, 2012
Status
Member
Last seen
September 27, 2012
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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!!

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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