I am trying to update 25 different spreadsheets, and have the latest row of
data from each of the 25 automatically go to a 26th spreadsheet that is my
summary.

My goal is anytime I add a new row of data in any of the 25, that the
summary sheet gets updated automatically.

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le message
de ...
I am trying to update 25 different spreadsheets, and have the latest row
of
data from each of the 25 automatically go to a 26th spreadsheet that is my
summary.

My goal is anytime I add a new row of data in any of the 25, that the
summary sheet gets updated automatically.

No. Each spreadsheet may/will vary, as far as row numbers.

"Ardus Petus" wrote:

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le message
de ...
I am trying to update 25 different spreadsheets, and have the latest row
of
data from each of the 25 automatically go to a 26th spreadsheet that is my
summary.

My goal is anytime I add a new row of data in any of the 25, that the
summary sheet gets updated automatically.

So you'll need some macro code (VBA).

Should the source data lines (ie A:Z) be copied into the same columns into
dest (master) worksheet?

Cheers,
--
AP

"av8tor9804" a écrit dans le message
de ...
No. Each spreadsheet may/will vary, as far as row numbers.

"Ardus Petus" wrote:

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le
message
de ...
I am trying to update 25 different spreadsheets, and have the latest
row
of
data from each of the 25 automatically go to a 26th spreadsheet that
is my
summary.

My goal is anytime I add a new row of data in any of the 25, that the
summary sheet gets updated automatically.

I have included a couple of the 25 workbooks, as well as the Combined
workbook, for you to download and play with to see what I'm describing. You
can download the ZIP file from www.runsheets.com

I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
automatically paste/hyperlink/update to the Combined workbook.

Thanks for any assistance you may provide.

BL





"Ardus Petus" wrote:

So you'll need some macro code (VBA).

Should the source data lines (ie A:Z) be copied into the same columns into
dest (master) worksheet?

Cheers,
--
AP

"av8tor9804" a écrit dans le message
de ...
No. Each spreadsheet may/will vary, as far as row numbers.

"Ardus Petus" wrote:

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le
message
de ...
I am trying to update 25 different spreadsheets, and have the latest
row
of
data from each of the 25 automatically go to a 26th spreadsheet that
is my
summary.

My goal is anytime I add a new row of data in any of the 25, that the
summary sheet gets updated automatically.

Here is your "Combined" Workbook with a macro named fillRows:
http://cjoint.com/?dhnhlyBWGv

HTH
--
AP

"av8tor9804" a écrit dans le message
de ...
I have included a couple of the 25 workbooks, as well as the Combined
workbook, for you to download and play with to see what I'm describing.
You
can download the ZIP file from www.runsheets.com

I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
automatically paste/hyperlink/update to the Combined workbook.

Thanks for any assistance you may provide.

BL





"Ardus Petus" wrote:

So you'll need some macro code (VBA).

Should the source data lines (ie A:Z) be copied into the same columns
into
dest (master) worksheet?

Cheers,
--
AP

"av8tor9804" a écrit dans le
message
de ...
No. Each spreadsheet may/will vary, as far as row numbers.

"Ardus Petus" wrote:

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le
message
de ...
I am trying to update 25 different spreadsheets, and have the
latest
row
of
data from each of the 25 automatically go to a 26th spreadsheet
that
is my
summary.

My goal is anytime I add a new row of data in any of the 25, that
the
summary sheet gets updated automatically.