Copy entire complete row between Signup Date word and === this sign and paste that data to abc.xlsx(note aabc.xlsx file is not opened we have to open the same by vba and also note that "Signup Date" word and "===" sign will be in column A and we have to copy entire row between this )
and also make a note there can be a chance it has two signup date
example
signup Date
XYZ A B C D
123
A/AB/C
===
SIGNUP DATE
854 E
HDFD F
DJF G
=====
So in this case copy both the data and paste it to aabc.xlsx
vba will be placed in a seprate file both the files are located in same place
open the file by vba do the process and save and close the file by vba
so plz have alook sir and do needful
and also make a note there can be a chance it has two signup date
example
signup Date
XYZ A B C D
123
A/AB/C
===
SIGNUP DATE
854 E
HDFD F
DJF G
=====
So in this case copy both the data and paste it to aabc.xlsx
vba will be placed in a seprate file both the files are located in same place
open the file by vba do the process and save and close the file by vba
so plz have alook sir and do needful