Hello ,
I have an excel file which is the source document and I have other excel files which are destination files all in one location.
- I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY.
- Check if column A has the word 'SIGNAPAY' ,
- If true then open a document called 'In process SIGNAPAY.xlsx' from that location,
- Click on the sheet name which matches with Column C (MM YYYY) of the source excel.
- Copy rows through columns A:G in the source excel for all rows which have SIGNAPAY in column A and paste into the last empty rows in the 'In Process SIGNAPAY.xlsx' workbook.
Below is what the data would look like:
<tbody>
</tbody>
I have an excel file which is the source document and I have other excel files which are destination files all in one location.
- I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY.
- Check if column A has the word 'SIGNAPAY' ,
- If true then open a document called 'In process SIGNAPAY.xlsx' from that location,
- Click on the sheet name which matches with Column C (MM YYYY) of the source excel.
- Copy rows through columns A:G in the source excel for all rows which have SIGNAPAY in column A and paste into the last empty rows in the 'In Process SIGNAPAY.xlsx' workbook.
Below is what the data would look like:
DMTITL | DHACCT | DHDATE | DHDATC | DHITC | DHAMT | DESC1 | DESC2 |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019189 | 70819 | 55 | 259 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019189 | 70819 | 55 | 499 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019189 | 70819 | 55 | 2795.81 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019189 | 70819 | 55 | 6000 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019189 | 70819 | 55 | 6500 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019190 | 70919 | 55 | 114 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 834.47 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 1590.7 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 2609.02 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 3294.32 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 4632.49 | Testing | Test Company |
SIGNAPAY LTD IN PROCESS ACCOUN | xxxxxxxxxx | 2019191 | 71019 | 18 | 6667.57 | Testing | Test Company |
<tbody>
</tbody>