Help with updating one spreadsheet off of another automatically
 

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.

Help with updating one spreadsheet off of another 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.

Help with updating one spreadsheet off of another automaticall
 

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).

"KC" wrote:

would you consider only having one summary sheet and
use auto filter to show any of the 25 sub sheets?

"av8tor9804" wrote:

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.

Help with updating one spreadsheet off of another automaticall
 

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.

Help with updating one spreadsheet off of another automaticall
 

It sounds like you're mixing up Worbooks & Worksheets.
What do you mean by "spreadsheet" ? A single file (Workbook) , or a file
(Workbook) containing 25 (Worksheets) ?

HTH
--
AP

"av8tor9804" a écrit dans le message
de ...
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).

"KC" wrote:

would you consider only having one summary sheet and
use auto filter to show any of the 25 sub sheets?

"av8tor9804" wrote:

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.

Help with updating one spreadsheet off of another automaticall
 

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.

Help with updating one spreadsheet off of another automaticall
 

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.

Help with updating one spreadsheet off of another automaticall
 

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.

Help with updating one spreadsheet off of another automaticall
 

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.
BL


"Ardus Petus" wrote:

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.

Help with updating one spreadsheet off of another automaticall
 

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
"1/0/00" 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



"Ardus Petus" wrote:

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.