Microsoft Office Questions? Ask a IT Expert for Support ASAP
if you send an example file, that would be helpful
maybe we will set something for tomarrow
i will be availible in the afternoon. my time of course
it is currently 9:00AM where I am.
This time I am sending an offer of additional service. It took too much of my time last time and was not very worth while for me.
my expertise is expensive, this is not knowledge I gained over night but 20 years experience working in excel.
However I will give a discount. But note that my rates are already considerably discounted.
i was not paid yet on this question. That does not happen until after I help you. But I will open your question up to other experts if you would like.
Sorry you feel this way.
you are also taking advantage of me. I spent over an hour with you yesterday. And gave you a working solution. You said "this is great", "It works".
You now have another unrelated issue and you expect me to spend more time for free. I told you I was willing to help you, but I cannot work on a 2nd issue for free.
I can also open this question up to another expert if that is what you wish.
If you feel that my 20 years of experience in this application is not useful to you then I will refer you to someone else. The formula I gave you yesterday gives you exactly what you requested, after I was finally able to understand what it was you wanted.
I have to make a living too, so cut me a little slack.
why would you loose your data if you change the reference number? The you can add as many sections for reference numbers as you want. If you have 100 reference numbers then you should have 100 of the sections that calculate balance if that is what you need?
well you would need to be more specific
if you change B238? is that the reference number you are changing?
yes do so
the only way to send to me is through***@******.*** and they will forward it.
But like I said the other day it may take a while for them to get it to me
do you have the wikisend link
the 2nd number did not work, will just have to wait for the email I guess
i have the sheet, when did W221 come into play.
You never mentioned W221 in your original request
so you are basically just looking for the same formula to be applied to other sheets as well
i have the sheet, I will cehck back later
i have the sheet up
i see, its number 40
ok, unfortunately this cannot work.
You can't have it both ways, the formula will change the data when the number in C221 changes. This is due to the way whoever set up the sheet in the first place did it.
it can't be done with a formula. Maybe with a macro. But that will make it more confusing for you
so the idea behind it would be that you would have to push a button to make it work, rather than it being done automatically