I have an Excel file (Chq Req) with two sheets Data (contains cheque #) and Report.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
1. I want to run a macro to copy the cheque # from Data (Cell D35)
2. Look for the next blank field under Report (Column E) and paste the cheque #
3. And, move the file (Chq Req) from original location (O:\Admin\Chq\Backup) to O:\Admin\Chq\Processed.
<o
></o
>
Thanks for help in advance
Taha
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
1. I want to run a macro to copy the cheque # from Data (Cell D35)
2. Look for the next blank field under Report (Column E) and paste the cheque #
3. And, move the file (Chq Req) from original location (O:\Admin\Chq\Backup) to O:\Admin\Chq\Processed.
<o
Thanks for help in advance
Taha