VBA coding to generate next number in a list in a closed workbook, use to extract row

Hi,

Having not coded for a long time and bitten off more than I can chew

It is a multilayered problem that ideally needs to be run from a single macro / command button

From a workbook (WB1) an experimental log I need to access a list in a closed workbook (WB2) all test dump and find the max value in a range in a column B, add 1 and append Max value plus 1 in the next row

this same number must be returned to a defined cell in WB1, this auto populates a reference on WB1, sheet 1 column 1 and I need to copy and append the entire row into the next empty row in WB2, sheet 2

any ideas....

really need some guidance can not believe how much I've forgotten

Originally Posted by Stephen Chi

... I need to access a list in a closed workbook (WB2) ... and I need to copy and append the entire row into the next empty row in WB2, sheet 2 ...

You can "download" data from a closed workbook (WB2), but you can not "add" data to a closed workbook (WB2), you must first open it.