VBA Macros to Copy data from closed workbook specific range

Hello Again,

I am looking for a help in VBA Macros where I can copy a last cell values for specific/fixed range.

I have 2 workbooks 1 is ClosedSheet and other one is Business.

What I am looking here is, the script look for the last cell values available in range from B18 until B31 from column B and what the last valuable cell values (Not Blank) should be copies in Business worksheet cell J27 copy value from column A for same last cell values in column B.

Example:
If the last cell value is B19 in ClosedSheet then the script should copy B19 from ClosedSheet to Business sheet in J27 and copy A19 from ClosedSheet to Business sheet in J6.

Below is my script which I am using now.

Please Login or Register  to view this content.

Thanks alpha i will check and get back to u

Its works.
Thanks once again.
Topic marked as solves abd reputation added.