I tried to copy and paste with ADO, but it does not work, maybe some one can
tell me a simple Macro
I have 1 workbook to copy date from many workbooks
1. Wkbook A looks like this
a b c d
1
2
3
4
2. All other wokbooks
a b c d e f g
1
2
3
4
5
6
Today I want to copy from all other workbook only e1 to G3, I copy and put
it to workbookA to A1to C3, but next day I will update by copying E1 to G6 ok
on this problem I can use dynamic range
but how can I have a Macro to let me:
1. Chose the file/workbook name to be copyied and pastied
2. when I put the cursor in cell A4, it will be pasted starting from this
cell, coz there will be many workbooks to be pasting in the workbook A which
is as a data bank for me.
The main problem, I want the Macro to put where I put the cursor in Workbook
A.
I appreciate your help.
Frank
|
Similar Threads
