Getting the last value in a different workbook

**KColgrove** · 01-31-2020, 01:09 PM

Hello,

I am trying to grab the last cell that has value that is in a different workbook. I need to pull from multiple workbooks, but the last cell with data will be different with each workbook. The data will always be in column "A" though.

Please Login or Register  to view this content.

**Leith Ross** · 01-31-2020, 01:53 PM

Hello KColgrove,

Is the problem with the other workbooks not being open?

Getting the last value in a different workbook

LinkBack

Thread Tools

Rate This Thread

Display

Getting the last value in a different workbook

Re: Getting the last value in a different workbook

Thread Information

Users Browsing this Thread

Similar Threads

Assign name to Workbook, Copy range from one workbook to another workbook

[SOLVED] VBA to open new workbook and run macro from new workbook, which closes old workbook

[SOLVED] Code to cut cell from one workbook, close same workbook, and paste in different workbook

Copy data one workbook to another workbook without opening workbook

[SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names

Save an open workbook, then open template workbook and close the saved workbook

[SOLVED] loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions