Analyzing quantity over value and pasting cells onto a new sheet

SamsonL

New Member
Joined
Jan 30, 2017
Messages
7
Hello Everyone,

Hope everyone is having a good Tuesday. I am unsure of how to formulate this code. If someone could help me in the right direction that would be greatly appreciated!

I have two sheets, 1 is Control Panel Size and the other is VFD Cabinet which the final answer will be copied onto a third sheet, the Heat Loss Sheet

My intention is whenever someone fills out the forms on the first two sheets, any component selected from both or either CP/VFD sheets that have a quantity greater than 0 (Column C for CP sheet and Column E for VFD sheet) will be copied and pasted (the entire row of the component) onto the heat loss sheet starting in A6. The copy and pasting will occur with a form that I have set up called 'Gather Components' when the user is finished with the first two sheets and moved on to the heat loss sheet.

Thanks!
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top