Hello all:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would be copied and amended to another cell in a different worksheet.
What I have is a Live (Technical) “worksheet” and an (Archive) “worksheet”
Any entries will be made by a “human” on the live (Technical) “worksheet” only, and the (Archive) “worksheet” is for a repository of historical data.
The formats of all the columns are the same for both worksheets, but the rows are not in the same order but referenced by a unique ID.
I am using two different columns for the entry of Data on the live (Technical) “worksheet” and where the data will need to be amended in the (Archive) “worksheet”
Any help is greatly appreciated.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would be copied and amended to another cell in a different worksheet.
What I have is a Live (Technical) “worksheet” and an (Archive) “worksheet”
Any entries will be made by a “human” on the live (Technical) “worksheet” only, and the (Archive) “worksheet” is for a repository of historical data.
The formats of all the columns are the same for both worksheets, but the rows are not in the same order but referenced by a unique ID.
I am using two different columns for the entry of Data on the live (Technical) “worksheet” and where the data will need to be amended in the (Archive) “worksheet”
Any help is greatly appreciated.
