patrickteo91
Board Regular
- Joined
- Sep 12, 2012
- Messages
- 88
Hi,
I am trying to automate my spreadsheet. Currently I have a template which i need to manually filter another workbook manually in order to get my required data. (Workbook A - template, Workbook B - Database).
Can anyone build a VBA script for me so that it will prompt me to select a file. Then it will compare the first 3 columns of Workbook B and copy the 4th and 5th column value into Workbook A ? Basically the template in Workbook A is exactly the same as workbook B.
It must be able to read signs like -, &, / , etc. and paste into the Date and Volumn column.
Thank you.
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I am trying to automate my spreadsheet. Currently I have a template which i need to manually filter another workbook manually in order to get my required data. (Workbook A - template, Workbook B - Database).
Can anyone build a VBA script for me so that it will prompt me to select a file. Then it will compare the first 3 columns of Workbook B and copy the 4th and 5th column value into Workbook A ? Basically the template in Workbook A is exactly the same as workbook B.
It must be able to read signs like -, &, / , etc. and paste into the Date and Volumn column.
Thank you.
Workbook A
<TBODY> </TBODY>
<TBODY> </TBODY> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Workbook B | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<TBODY> </TBODY> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>