chintanpatel
New Member
- Joined
- Apr 15, 2022
- Messages
- 2
- Office Version
- 2011
- Platform
- Windows
Hi ,
I need to copy and paste data based on certain conditions are met in tab 2 data. The conditions are will be in tab 1.
I have managed to get data spilt into diffrent tabs.
The most challeging part for me is date section in tab 2 column 3, is in dd/mm/yyyy HH:mm:ss, one of the condition I need to meet is if user enters the date say 10/04/2022 as a start date and end date is 11/04/2022 and I need to copy data from tab 2 from 10/04/2022 12:00:00 midday to 11/04/2022 midday only.
I need to copy and paste data based on certain conditions are met in tab 2 data. The conditions are will be in tab 1.
I have managed to get data spilt into diffrent tabs.
The most challeging part for me is date section in tab 2 column 3, is in dd/mm/yyyy HH:mm:ss, one of the condition I need to meet is if user enters the date say 10/04/2022 as a start date and end date is 11/04/2022 and I need to copy data from tab 2 from 10/04/2022 12:00:00 midday to 11/04/2022 midday only.