M
MikeC2909
HI, I wonder if anyone can assist? I run a workbook where data in on
worksheet is automatically copied to another worksheet upon data entr
in the original sheet. This original data entry tells me the likel
estimated commission I am set to gain if a particular piece of busines
is successful! So, I can have "at a glance" details of what estimates
have issued. Once I know that the particular piece of business has bee
a success and I can issue an invoice, I then enter the invoice amoun
into the original worksheet - obviously. to a different column, but fo
the same customer record in the same row as the original estimate amoun
- and, again, the invoice amount automatically transfers to a cell i
the same (second) worksheet as the estimated amount. What I'd like t
happen is for Excel to delete the copied "estimated amount" data fro
the second worksheet once the "invoice amount" is copied across......d
you think this is possible and, if so, how would you solve it?
To recap (and to try and explain it simply!)
Step 1 in Worksheet 1 - For each customer, estimated amount entered i
automatically transferred to a cell in Worksheet 2 via the "Copy an
Paste Link" process. The formula in that cell (the "receiving" cell i
Worksheet 2)) is: ='Customer contact record'!Y8 Of course, Y
represents the particular cell in worksheet 1 where the data has com
from. The same formula applies in the colmun in worksheet 2 - in othe
words, as I create a customer record in Worksheet 1, all relevant dat
is copied to worksheet 2, so - in the case of the formula above - Y8 ma
be Y9,, Y10, etc et
Step 2 in Worksheet 1 - For each customer, confirmed invoice amoun
entered is transferred to a new cell in worksheet 2. Same principle a
above, but to a different column. As this happens, I'd like th
estimated amount for that customer in worksheet 2 (ie that previousl
transferred form worksheet 1 as per above) to be automatically delete
from the cell it has been copied to, and for that cell to then b
blank..
Thanks in advance of any replies!
worksheet is automatically copied to another worksheet upon data entr
in the original sheet. This original data entry tells me the likel
estimated commission I am set to gain if a particular piece of busines
is successful! So, I can have "at a glance" details of what estimates
have issued. Once I know that the particular piece of business has bee
a success and I can issue an invoice, I then enter the invoice amoun
into the original worksheet - obviously. to a different column, but fo
the same customer record in the same row as the original estimate amoun
- and, again, the invoice amount automatically transfers to a cell i
the same (second) worksheet as the estimated amount. What I'd like t
happen is for Excel to delete the copied "estimated amount" data fro
the second worksheet once the "invoice amount" is copied across......d
you think this is possible and, if so, how would you solve it?
To recap (and to try and explain it simply!)
Step 1 in Worksheet 1 - For each customer, estimated amount entered i
automatically transferred to a cell in Worksheet 2 via the "Copy an
Paste Link" process. The formula in that cell (the "receiving" cell i
Worksheet 2)) is: ='Customer contact record'!Y8 Of course, Y
represents the particular cell in worksheet 1 where the data has com
from. The same formula applies in the colmun in worksheet 2 - in othe
words, as I create a customer record in Worksheet 1, all relevant dat
is copied to worksheet 2, so - in the case of the formula above - Y8 ma
be Y9,, Y10, etc et
Step 2 in Worksheet 1 - For each customer, confirmed invoice amoun
entered is transferred to a new cell in worksheet 2. Same principle a
above, but to a different column. As this happens, I'd like th
estimated amount for that customer in worksheet 2 (ie that previousl
transferred form worksheet 1 as per above) to be automatically delete
from the cell it has been copied to, and for that cell to then b
blank..
Thanks in advance of any replies!