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!
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!