Is there anyone who can help me with this? I cannot figure this out and need this spreadsheet working asap for my boss and salesreps.
I've tried the IF function, Advanced Filter option, LOOKUP, but can't get anything to work and don't really know macros but am trying to learn.
Within my workbook there are 14 sheets but only 4 sheets that have Part #s that when a quantity >0 is entered in column E, the corresponding data from that row (ie: B4:G4) needs to copy over to the master material sheet 'MATL LIST' (ie starting at: A5:F5). And then as more parts/quantities are entered throughout each 4 sheets, the data from that row fills in the 'MATL LIST' sheet right after the last one entered.
1) '2 Voice-Evac'
2) '3 FARADAY'
3) '4 SINORIX'
4) '5 Sig Bat'
5) 'MATL LIST' (columns G:I must not change)
I've attached a dummy_before & dummy_after
This seems like it should be an easy deal, but am drawing a blank for some reason.
Any help is very much appreciated!!
Bookmarks