PDA

View Full Version : Excel nerds.. helpith!


Parkbandit
10-03-2005, 07:14 PM
I have a spreadsheet that has lookup formulas in it from a database. I want to take that spreadsheet, once it's done looking up everything and copy it over to another sheet.. changing the values from formulas to actual numbers.

Is that possible?

Example : Cell a4 has the formula - =VLOOKUP($B$1,'Essbase (2)'!$A$10:$BA$120,21,FALSE)/VLOOKUP($B$1,'Essbase (2)'!$A$10:$BA$120,38,FALSE)

and it returnes the value of 95.5%

I want to copy that cell to another spreadsheet and ONLY keep the value of 95.5% and drop the formula.

Help me!
Wezas
10-03-2005, 07:18 PM
Copy
Paste Special (Value)
Bobmuhthol
10-03-2005, 07:18 PM
rofl I have no fucking clue what any of that means.

I really need to start reading some of the books I have. I've got something on programming using VisualBasic in Excel, then I started to learn Ruby, then I went to school. :(
Parkbandit
10-03-2005, 07:20 PM
Nice Wezas.

Thanks.

You saved me about 3 hours of fucking work tonight.
Wezas
10-03-2005, 07:26 PM
Hand over your stalker notes on Jesae and we'll call it even.

I know I must have missed something at some point.
Parkbandit
10-03-2005, 07:41 PM
Originally posted by Wezas
Hand over your stalker notes on Jesae and we'll call it even.

I know I must have missed something at some point.

Does this include wire taps, video surveillance and still photos??

I'll need to see some sort of warrant or large cashier's check before I turn these gems over. Telephoto lenses, night vision technology and hidden cameras are not cheap man.
Wezas
10-03-2005, 07:48 PM
Originally posted by Parkbandit

Originally posted by Wezas
Hand over your stalker notes on Jesae and we'll call it even.

I know I must have missed something at some point.

Does this include wire taps, video surveillance and still photos??

Depends what's in the video/pictures. Wire taps you can keep unless they're juicy.
Parkbandit
10-03-2005, 07:54 PM
Originally posted by Wezas

Originally posted by Parkbandit

Originally posted by Wezas
Hand over your stalker notes on Jesae and we'll call it even.

I know I must have missed something at some point.

Does this include wire taps, video surveillance and still photos??

Depends what's in the video/pictures. Wire taps you can keep unless they're juicy.

Oh, it's good. You will want these, trust me.