Posted: Thu Jan 05, 2006 7:28 am Post subject: copy & paste data from workbooks to master workbook
[b]i want to automate this action using VBA
I have workbooks representing data about invoices
& I want to copy the data & paste them in a master workbook as a running database
the invoices have the same format (template form) so as to be user for macros
how can I do that
I need at least the schematic of the code & how to start
I already recorded macro but dont know how to manipulate it so as to pick every invoice & paste it in a row instead of just that one invocie workbook
how can I use the targetcolumn & source data in the code
appreciate any help
if u need more explaination I will provide[/b]
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum