software

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 quot;latestquot; row in each worksheet the same row number?

--
AP

quot;av8tor9804quot; gt; a écrit dans le message
de ...
gt; I am trying to update 25 different spreadsheets, and have the latest row
of
gt; data from each of the 25 automatically go to a 26th spreadsheet that is my
gt; summary.
gt;
gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; summary sheet gets updated automatically.
Do you mean 1 summary worksheet and 25 sub-worksheets? I would prefer to keep
them as separate spreadsheets (and not worksheets of the same excel file),
due to the fact that each of the 25 has 2 worksheets apiece (1 for data
entry, 1 for cumulative data review).

quot;KCquot; wrote:

gt; would you consider only having one summary sheet and
gt; use auto filter to show any of the 25 sub sheets?
gt;
gt; quot;av8tor9804quot; wrote:
gt;
gt; gt; I am trying to update 25 different spreadsheets, and have the latest row of
gt; gt; data from each of the 25 automatically go to a 26th spreadsheet that is my
gt; gt; summary.
gt; gt;
gt; gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; gt; summary sheet gets updated automatically.

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

quot;Ardus Petusquot; wrote:

gt; Has the quot;latestquot; row in each worksheet the same row number?
gt;
gt; --
gt; AP
gt;
gt; quot;av8tor9804quot; gt; a écrit dans le message
gt; de ...
gt; gt; I am trying to update 25 different spreadsheets, and have the latest row
gt; of
gt; gt; data from each of the 25 automatically go to a 26th spreadsheet that is my
gt; gt; summary.
gt; gt;
gt; gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; gt; summary sheet gets updated automatically.
gt;
gt;
gt;

It sounds like you're mixing up Worbooks amp; Worksheets.
What do you mean by quot;spreadsheetquot; ? A single file (Workbook) , or a file
(Workbook) containing 25 (Worksheets) ?

HTH
--
AP

quot;av8tor9804quot; gt; a écrit dans le message
de ...
gt; Do you mean 1 summary worksheet and 25 sub-worksheets? I would prefer to
keep
gt; them as separate spreadsheets (and not worksheets of the same excel file),
gt; due to the fact that each of the 25 has 2 worksheets apiece (1 for data
gt; entry, 1 for cumulative data review).
gt;
gt; quot;KCquot; wrote:
gt;
gt; gt; would you consider only having one summary sheet and
gt; gt; use auto filter to show any of the 25 sub sheets?
gt; gt;
gt; gt; quot;av8tor9804quot; wrote:
gt; gt;
gt; gt; gt; I am trying to update 25 different spreadsheets, and have the latest
row of
gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet that
is my
gt; gt; gt; summary.
gt; gt; gt;
gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; gt; gt; 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

quot;av8tor9804quot; gt; a écrit dans le message
de news
gt; No. Each spreadsheet may/will vary, as far as row numbers.
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; Has the quot;latestquot; row in each worksheet the same row number?
gt; gt;
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;av8tor9804quot; gt; a écrit dans le
message
gt; gt; de ...
gt; gt; gt; I am trying to update 25 different spreadsheets, and have the latest
row
gt; gt; of
gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet that
is my
gt; gt; gt; summary.
gt; gt; gt;
gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; gt; gt; summary sheet gets updated automatically.
gt; gt;
gt; gt;
gt; gt;
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.

BLquot;Ardus Petusquot; wrote:

gt; So you'll need some macro code (VBA).
gt;
gt; Should the source data lines (ie A:Z) be copied into the same columns into
gt; dest (master) worksheet?
gt;
gt; Cheers,
gt; --
gt; AP
gt;
gt; quot;av8tor9804quot; gt; a écrit dans le message
gt; de news
gt; gt; No. Each spreadsheet may/will vary, as far as row numbers.
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt; gt; Has the quot;latestquot; row in each worksheet the same row number?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; message
gt; gt; gt; de ...
gt; gt; gt; gt; I am trying to update 25 different spreadsheets, and have the latest
gt; row
gt; gt; gt; of
gt; gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet that
gt; is my
gt; gt; gt; gt; summary.
gt; gt; gt; gt;
gt; gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that the
gt; gt; gt; gt; summary sheet gets updated automatically.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Here is your quot;Combinedquot; Workbook with a macro named fillRows:
cjoint.com/?dhnhlyBWGv

HTH
--
AP

quot;av8tor9804quot; gt; a écrit dans le message
de ...
gt; I have included a couple of the 25 workbooks, as well as the Combined
gt; workbook, for you to download and play with to see what I'm describing.
You
gt; can download the ZIP file from www.runsheets.com
gt;
gt; I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
gt; automatically paste/hyperlink/update to the Combined workbook.
gt;
gt; Thanks for any assistance you may provide.
gt;
gt; BL
gt;
gt;
gt;
gt;
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; So you'll need some macro code (VBA).
gt; gt;
gt; gt; Should the source data lines (ie A:Z) be copied into the same columns
into
gt; gt; dest (master) worksheet?
gt; gt;
gt; gt; Cheers,
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;av8tor9804quot; gt; a écrit dans le
message
gt; gt; de news
gt; gt; gt; No. Each spreadsheet may/will vary, as far as row numbers.
gt; gt; gt;
gt; gt; gt; quot;Ardus Petusquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Has the quot;latestquot; row in each worksheet the same row number?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; AP
gt; gt; gt; gt;
gt; gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; gt; message
gt; gt; gt; gt; de ...
gt; gt; gt; gt; gt; I am trying to update 25 different spreadsheets, and have the
latest
gt; gt; row
gt; gt; gt; gt; of
gt; gt; gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet
that
gt; gt; is my
gt; gt; gt; gt; gt; summary.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that
the
gt; gt; gt; gt; gt; summary sheet gets updated automatically.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
Thank you so much.

I apologoze about the delay in re-checking the responses here. It's been a
busy couple of days. I have downloaded the file and will check it out
shortly.

Thanks again.
BLquot;Ardus Petusquot; wrote:

gt; Here is your quot;Combinedquot; Workbook with a macro named fillRows:
gt; cjoint.com/?dhnhlyBWGv
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;av8tor9804quot; gt; a écrit dans le message
gt; de ...
gt; gt; I have included a couple of the 25 workbooks, as well as the Combined
gt; gt; workbook, for you to download and play with to see what I'm describing.
gt; You
gt; gt; can download the ZIP file from www.runsheets.com
gt; gt;
gt; gt; I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
gt; gt; automatically paste/hyperlink/update to the Combined workbook.
gt; gt;
gt; gt; Thanks for any assistance you may provide.
gt; gt;
gt; gt; BL
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt; gt; So you'll need some macro code (VBA).
gt; gt; gt;
gt; gt; gt; Should the source data lines (ie A:Z) be copied into the same columns
gt; into
gt; gt; gt; dest (master) worksheet?
gt; gt; gt;
gt; gt; gt; Cheers,
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; message
gt; gt; gt; de news
gt; gt; gt; gt; No. Each spreadsheet may/will vary, as far as row numbers.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ardus Petusquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Has the quot;latestquot; row in each worksheet the same row number?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; AP
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; gt; gt; message
gt; gt; gt; gt; gt; de ...
gt; gt; gt; gt; gt; gt; I am trying to update 25 different spreadsheets, and have the
gt; latest
gt; gt; gt; row
gt; gt; gt; gt; gt; of
gt; gt; gt; gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet
gt; that
gt; gt; gt; is my
gt; gt; gt; gt; gt; gt; summary.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that
gt; the
gt; gt; gt; gt; gt; gt; summary sheet gets updated automatically.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

So I've spent some time trying to get the rows to fill in automatically when
I run the macro, and time after time, all it will fill in is a log date of
quot;1/0/00quot; and a log # of 0. What am I doing incorrectly? In reviewing the
macro code, i thought maybe starting in cell A3 instead of A2 may provide
results, but that only made the 'Combined' sheet unable to find the target
workbook to open. I changed the starting cell back to A2, and at least it
does again all it ever did, which is above.

I appreciate your help. What can I do next?

Regards,
BL
quot;Ardus Petusquot; wrote:

gt; Here is your quot;Combinedquot; Workbook with a macro named fillRows:
gt; cjoint.com/?dhnhlyBWGv
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;av8tor9804quot; gt; a écrit dans le message
gt; de ...
gt; gt; I have included a couple of the 25 workbooks, as well as the Combined
gt; gt; workbook, for you to download and play with to see what I'm describing.
gt; You
gt; gt; can download the ZIP file from www.runsheets.com
gt; gt;
gt; gt; I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
gt; gt; automatically paste/hyperlink/update to the Combined workbook.
gt; gt;
gt; gt; Thanks for any assistance you may provide.
gt; gt;
gt; gt; BL
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt; gt; So you'll need some macro code (VBA).
gt; gt; gt;
gt; gt; gt; Should the source data lines (ie A:Z) be copied into the same columns
gt; into
gt; gt; gt; dest (master) worksheet?
gt; gt; gt;
gt; gt; gt; Cheers,
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; message
gt; gt; gt; de news
gt; gt; gt; gt; No. Each spreadsheet may/will vary, as far as row numbers.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ardus Petusquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Has the quot;latestquot; row in each worksheet the same row number?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; AP
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;av8tor9804quot; gt; a écrit dans le
gt; gt; gt; message
gt; gt; gt; gt; gt; de ...
gt; gt; gt; gt; gt; gt; I am trying to update 25 different spreadsheets, and have the
gt; latest
gt; gt; gt; row
gt; gt; gt; gt; gt; of
gt; gt; gt; gt; gt; gt; data from each of the 25 automatically go to a 26th spreadsheet
gt; that
gt; gt; gt; is my
gt; gt; gt; gt; gt; gt; summary.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; My goal is anytime I add a new row of data in any of the 25, that
gt; the
gt; gt; gt; gt; gt; gt; summary sheet gets updated automatically.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;