copying cell from different workbook

[kwun23]

I am very new in VBA. Just get a new task from my new boss regarding getting cell data from different workbook.

Let’s see my need as below:

1) I need to copy different cell data to a workbook call “destination” from different workbooks
2) The different workbooks I copied from name as below:
VBA 01 SEP
VBA 02 SEP
VBA 03 SEP
VBA 04 SEP
VBA 05 SEP
VBA 06 SEP
VBA 07 SEP
3) I only need cell Z1 from the above workbook
I would like to copy the cell “Z1” of “VBA 01 SEP” to “destination A1”
cell “Z1” of “VBA 02 SEP” to” destination A2”
cell “Z1” of “VBA 03 SEP” to” destination A3”
cell “Z1” of “VBA 04 SEP” to” destination A4”
cell “Z1” of “VBA 05 SEP” to” destination A5”
cell “Z1” of “VBA 06 SEP” to” destination A6”

Can anyone suggest some template for me? Many thanks.

[Fotis1991]

Welcome to the forum.

Why don't you record a macro for doing this?

[kwun23]

Thanks Fotis for the prompt reply

It is because the date is keep changing, actually, the workbook i need to copy is from 1 Jan 2001 until now and going foward.

The below is my stupid command code, it may be a bit longer, as i need to copy more than 9 cells from each work book


EDIT:

I am sorry but trying to add code tags around your code as per forum rules i deleted your code. Can you pls post your code again adding code tags arround it?

[kwun23]

Sorry for no adding the code tag

Please see below for the code again, thanks all

Please Login or Register  to view this content.