E
EvanVLane
Hey everybody,
I'm making a workbook that will be distributed to several department
managers.
On my end, I want to have a workbook that adds each row from their
books to a sheet in mine and if there is an "UPDATE" in one of the
cells on that row I want that row to be appended to another sheet that
I can print out for each day's updates. I understand using the today()
function, but I need to know how to check for new data across workbooks
and append it to a sheet. Also I need to figure out how to check for
the string value of a cell.
I'm not sure if that makes any sense, so here's an example:
Bob updates his workbook with a new row that reads roughly:
"4/5/06---PM Meeting--- UPDATE" (with each thing in a separate cell)
John updates his workbook with a new row that reads roughly:
"4/6/06---Dev Meeting--- UPDATE" (with each thing in a separate cell)
Mike updates his workbook with a new row that reads roughly:
"4/5/06---Lunch meeting with Mr. Donner-- [blank]" (with each thing in
a separate cell)
In my workbook when I open it, it will have updated Bob's, John's, and
Mike's sheets with the new row. (Or if it's easier, just refresh the
entire sheet with their entire sheet on opening... that may be easier
if they make changes to prior entries, I suppose).
When I page over to the 'Update' sheet, it will only have the data from
Bob's and John's sheet (and have been cleared of the data from the day
before).
I know it's kinda complicated, but if I can figure this out (if it's
even possible in Excel) it stands to save me 'bout 2 hours a day.
Oh.. And I'm not too good with the VB side of things in Excel... But if
it comes down to that I should be able to work through any advice you
give me.
Thanks!
Evan.
I'm making a workbook that will be distributed to several department
managers.
On my end, I want to have a workbook that adds each row from their
books to a sheet in mine and if there is an "UPDATE" in one of the
cells on that row I want that row to be appended to another sheet that
I can print out for each day's updates. I understand using the today()
function, but I need to know how to check for new data across workbooks
and append it to a sheet. Also I need to figure out how to check for
the string value of a cell.
I'm not sure if that makes any sense, so here's an example:
Bob updates his workbook with a new row that reads roughly:
"4/5/06---PM Meeting--- UPDATE" (with each thing in a separate cell)
John updates his workbook with a new row that reads roughly:
"4/6/06---Dev Meeting--- UPDATE" (with each thing in a separate cell)
Mike updates his workbook with a new row that reads roughly:
"4/5/06---Lunch meeting with Mr. Donner-- [blank]" (with each thing in
a separate cell)
In my workbook when I open it, it will have updated Bob's, John's, and
Mike's sheets with the new row. (Or if it's easier, just refresh the
entire sheet with their entire sheet on opening... that may be easier
if they make changes to prior entries, I suppose).
When I page over to the 'Update' sheet, it will only have the data from
Bob's and John's sheet (and have been cleared of the data from the day
before).
I know it's kinda complicated, but if I can figure this out (if it's
even possible in Excel) it stands to save me 'bout 2 hours a day.
Oh.. And I'm not too good with the VB side of things in Excel... But if
it comes down to that I should be able to work through any advice you
give me.
Thanks!
Evan.