D
dhcv
We use a spreadsheet to track the location of reports and the date they are
sent to that location. We currently add that information at the end of text
in our "Status" cells. I want to make it so we can enter the new data into
an empty cell or cells and have the history of entries automatically updated
in either the "Status" cells (separated by a "/") or on a separate worksheet
using separate cells for each entry.
I am not familiar enough with visual basic or macros to make it work. I
keep getting circular references which I have been able to use to get it to
work by allowing it to do iterations but it puts the same info at the end of
the text string even when a cell on a different row is updated.
I'll try to show you an example of what we currently have:
-- new report, 1 Jan 07: Section
-- report draft, 1 Jan 07: Section / 8 Jan 07: Office
-- correct draft, 1 Jan 07: Section / 8 Jan 07: Office / 15 Jan 07: Section
I also would like to be able to count how many times it has been in any
location.
I'm using Excel 2003.
sent to that location. We currently add that information at the end of text
in our "Status" cells. I want to make it so we can enter the new data into
an empty cell or cells and have the history of entries automatically updated
in either the "Status" cells (separated by a "/") or on a separate worksheet
using separate cells for each entry.
I am not familiar enough with visual basic or macros to make it work. I
keep getting circular references which I have been able to use to get it to
work by allowing it to do iterations but it puts the same info at the end of
the text string even when a cell on a different row is updated.
I'll try to show you an example of what we currently have:
-- new report, 1 Jan 07: Section
-- report draft, 1 Jan 07: Section / 8 Jan 07: Office
-- correct draft, 1 Jan 07: Section / 8 Jan 07: Office / 15 Jan 07: Section
I also would like to be able to count how many times it has been in any
location.
I'm using Excel 2003.