jigglypuff
New Member
- Joined
- Mar 28, 2013
- Messages
- 25
Guys I am not an expert in excel but have some experience and I foresee that I will have to work with it a lot in the future. I am facing some problems right now and would appreciate your help. Let's see them:
I am working on a sheet where I'd like to write a number in a given cell -- let's say A1 -- and them for the moment I would like that that input were converted to its value in US Dollars -- let's say in the cell B1 -- a THAT moment, and then I want the same value in dollars appeared in another cell, let's say now the C1 but now I want that value fixed and I am having a lot of trouble on it. Let me explain: I want one of the conversions changing through the time as the dollar value changes in the market, and the other one I want frozen in time, showing the value in dollars at the time I put the value in my currency.
I am not an expert in VBA (actually I know almost nothing) and work most of the time using the easier features of the excel. I will explain how I am trying to do this task: I imported from the internet a graph from the internet which shows in real time the value of a dollar compared to a 'real' (my monetary unity), then I programmed the cell B1 to always multiplies the value in the cell A1 so it would give me the value in dollars, and it really does it but it is changing all the time! I need one of them changing and the another one frozen at the time the calculations were made! Is it possible?
Another problem I have with this issue is: in order to make the things easier to me when I know I will use the formula more than once I just copy and paste it all way down a given column and some of the factors in the equations magically becomes others. e.g.: I am trying to copy this formula
=C5*Sheet4!D32
but when I copy it some lines down in the same column it becomes
=C24*Sheet4!D51
actually I need it to become C24 but I also need that the D32 stay the same and it is changing, is there any way to fix it? To decide which factor changes and which one stays the same?
Thank you in advance, I appreciate your help. If I have committed any mistakes, please forgive me, I am not a native English speaker nor am I an expert in excel :P
I am working on a sheet where I'd like to write a number in a given cell -- let's say A1 -- and them for the moment I would like that that input were converted to its value in US Dollars -- let's say in the cell B1 -- a THAT moment, and then I want the same value in dollars appeared in another cell, let's say now the C1 but now I want that value fixed and I am having a lot of trouble on it. Let me explain: I want one of the conversions changing through the time as the dollar value changes in the market, and the other one I want frozen in time, showing the value in dollars at the time I put the value in my currency.
I am not an expert in VBA (actually I know almost nothing) and work most of the time using the easier features of the excel. I will explain how I am trying to do this task: I imported from the internet a graph from the internet which shows in real time the value of a dollar compared to a 'real' (my monetary unity), then I programmed the cell B1 to always multiplies the value in the cell A1 so it would give me the value in dollars, and it really does it but it is changing all the time! I need one of them changing and the another one frozen at the time the calculations were made! Is it possible?
Another problem I have with this issue is: in order to make the things easier to me when I know I will use the formula more than once I just copy and paste it all way down a given column and some of the factors in the equations magically becomes others. e.g.: I am trying to copy this formula
=C5*Sheet4!D32
but when I copy it some lines down in the same column it becomes
=C24*Sheet4!D51
actually I need it to become C24 but I also need that the D32 stay the same and it is changing, is there any way to fix it? To decide which factor changes and which one stays the same?
Thank you in advance, I appreciate your help. If I have committed any mistakes, please forgive me, I am not a native English speaker nor am I an expert in excel :P