copying data

T

tel

hi to all!

I have a problem, i need a macro/VBA that will extract the data from
range.("C5") of different workbooks and paste it to the column A of
masterlist workbook. I'm having problems because i don't know what code
to use so that i don't have to specify the file name of the different
workbook and don't have to open all the workbooks one by one.

i've been searching but still no luck and the fact that i'm new in VBA
does not help... :(

any help is greatly appreciated...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update validation list based on end date 2
Import multiple workbooks to current workbook in specified row number 0
Pulling data from one workbook to another one using VBA 0
How to append data from different sheet and different workbook? 2
vba code does not run 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
Saying No to Message Box prompt through VBA 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top