kkyuvaraj
04-25-2019, 04:30 AM
Hi,
I have an excel sheet (Attached in this thread) with sheets "Checklist" & "CAR", in which i need a VBA code in the checklist sheer in "Generate CAR" button and if click that button CAR report to be generated in "CAR" sheet as provided in the attached excel sheet.
1. VBA code should filter the field "I5" if I6 to I127=CAR, then the filtered data from C6:H127 has to be copied and pasted to "CAR" sheet as given in the attached excel.
2.Further if any data changed in "Checklist" and I click "Generate CAP" again then the previously copied/pasted data in "CAR" has to be removed and fresh data has to be copied & pasted in "CAR" sheet.
3. After copy & paste to "CAR", checklist list show full list without filter.
Experts pls help to create the VBA code as above
by
Yuvaraj
I have an excel sheet (Attached in this thread) with sheets "Checklist" & "CAR", in which i need a VBA code in the checklist sheer in "Generate CAR" button and if click that button CAR report to be generated in "CAR" sheet as provided in the attached excel sheet.
1. VBA code should filter the field "I5" if I6 to I127=CAR, then the filtered data from C6:H127 has to be copied and pasted to "CAR" sheet as given in the attached excel.
2.Further if any data changed in "Checklist" and I click "Generate CAP" again then the previously copied/pasted data in "CAR" has to be removed and fresh data has to be copied & pasted in "CAR" sheet.
3. After copy & paste to "CAR", checklist list show full list without filter.
Experts pls help to create the VBA code as above
by
Yuvaraj