Howardc
04-20-2013, 10:07 AM
I need a macro to do the following
1) To give option select a workbook workbook in directory c:\my documents
2) To compare the name on the source workbook (Source Vat Report.sample1) in Cell B1 to the name in Col B of the destination workbook and if they match to copy-see sheet "Table"
a) the value in Col B in line with V.A.T. On Sales to Col H on active sheet of the destination workbook
b) the value in Col B in line with V.A.T. On Purchases to Col G on active sheet of the destination workbook
c) the value in Col B in line with Sales To Internal to Col M on active sheet of the destination workbook
Your assistance in this regard is most appreciated
1) To give option select a workbook workbook in directory c:\my documents
2) To compare the name on the source workbook (Source Vat Report.sample1) in Cell B1 to the name in Col B of the destination workbook and if they match to copy-see sheet "Table"
a) the value in Col B in line with V.A.T. On Sales to Col H on active sheet of the destination workbook
b) the value in Col B in line with V.A.T. On Purchases to Col G on active sheet of the destination workbook
c) the value in Col B in line with Sales To Internal to Col M on active sheet of the destination workbook
Your assistance in this regard is most appreciated