| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
CharmingButIrrational
Roswell Project Victimz
   |
Posted - 2011.02.12 19:38:00 -
[1]
I have a spreadsheet at work that we use to store some data for backup purposes. In it's current form it's a little bit of a pain for something that will only get used again 0.01% of the time. I've been looking into automating some bits to make it a little less of a pain in the arse.
Now onto the content:
In C13 a huge chunck of data gets dumped into it that I can extract some useful bits from into other cells; B4, B7 and B13 onwards. I have the formulas setup to do this, so no worries there. What I have a problem with is that ideally I need to be able to export those formula results to the cells without having formulas in them. Sometimes we don't have the data for C13 so the other cells have to be entered manually. Not having the formulas in the cells is a usability issue that I can't get around.
From what I've managed to garner from google is that Excel can't do this with forumlas, only a macro(s). What I'm looking for is if someone can show me how to build one that does what I need, either with a code example or pointing me to some web references that can help me get my head around it quickly. I've got a 100mil reward for the code example, with an extra 50 up for grabs if you can break it down into a simple english explanation. Will also provide some isk for linked web references I find useful in getting this built myself.
Recap: So I'm looking to have the B4 formula in say L1 to post its result back to B4; B7 in L2; B13 > in L3 >. For clarification the B13 > results are all distinct results and could potentially be in the order of hundreds(if this is too complicated to implement leave it). The macro would need to automatically post the forumla results in their respective output cells without any human intervention if this is possible.
|
AlleyKat
Gallente
The Unwanted.
|
Posted - 2011.02.12 19:48:00 -
[2]
Use the record function for a new marco and do the process once manually. Then save it.
150 mill please.
AK
EVE-ONLINE Video-Making Tutorials
Vid - New Tricks |
CharmingButIrrational
Roswell Project Victimz
|
Posted - 2011.02.12 21:25:00 -
[3]
Not so fast cowboy. That doesn't cover getting the macro to auto execute when a value appears in the formula box. There has to be no human interaction on the macro side.
This is the formula I'm working with =IF(A1="","",MID(A1,FIND(ôXXXXô,A1)0,0)) so when the formula returns any value other than "" the macro needs to do it's thing.
I've found examples of code that'll in principle do sort of what I'm looking for, but a lot what I understand is just guess work and not enough to adapt it to my needs.
|
Louis deGuerre
Gallente
Malevolence.
Imperial 0rder
|
Posted - 2011.02.12 22:26:00 -
[4]
I'm sorry but we decided to hire the other candidate 
-----
Malevolence. is recruiting. Dive into the world of 0.0 !
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |