Who knows excel really well? - GoFuckYourself.com

BradM · 07-09-2004, 02:50 PM

Is there a way that you can change a dynamic column to the static value that was calculated for it?

Example the column right now is
=D4*$C$294

But I want it to be the value that was calculated from it, so that I can remove one of the columns it is using to calculate the value with.

Follow me?

pornstar2pac · 07-09-2004, 02:51 PM

I have the same question

BradM · 07-09-2004, 03:08 PM

bizump

jayeff · 07-09-2004, 03:08 PM

Highlight the column --> Ctrl+C: don't move the cursor*.

Menu bar --> Edit --> Paste Special [select values] --> Okay

* You can paste the column somewhere else if you want [to be safe]. In that case just put the cursor wherever you want the top of the column to appear.

BradM · 07-09-2004, 03:12 PM

Quote:

Originally posted by jayeff
Highlight the column --> Ctrl+C: don't move the cursor*.

Menu bar --> Edit --> Paste Special [select values] --> Okay

* You can paste the column somewhere else if you want [to be safe]. In that case just put the cursor wherever you want the top of the column to appear.

Dude. I owe you a night of steamy hot sex.

Thank you very much.

punker barbie · 07-09-2004, 03:15 PM

Quote:

Originally posted by BradM
Dude. I owe you a night of steamy hot sex.

Thank you very much.

YAY man love! must be my lucky day!

Calvinguy · 07-09-2004, 04:09 PM

I use excel for my mysql table info. Can you in some way by a macro make a function that will take the info from some fields and make a SQL query to copy and paste into myphpadmin?

wyldblyss · 07-09-2004, 04:16 PM

Wow man lovins as a reward! Now is that a good thing or a bad thing?

punker barbie · 07-09-2004, 04:24 PM

Quote:

Originally posted by wyldblyss
Wow man lovins as a reward! Now is that a good thing or a bad thing?

its a great thing ! ;)

jayeff · 07-09-2004, 04:48 PM

Quote:

Originally posted by Calvinguy
I use excel for my mysql table info. Can you in some way by a macro make a function that will take the info from some fields and make a SQL query to copy and paste into myphpadmin?

Use the concatenate feature. With it you can string together a bunch of text and (different) cell values in pretty much any way you like.

F1 (help) should show you the way.

BlueDesignStudios · 07-09-2004, 05:15 PM

Quote:

Originally posted by jayeff
Use the concatenate feature. With it you can string together a bunch of text and (different) cell values in pretty much any way you like.

F1 (help) should show you the way.

wow.. this guys a pro

07-09-2004, 02:50 PM	#1
BradM Confirmed User Join Date: Dec 2003 Location: 1123,6536,5231 Posts: 3,397	Who knows excel really well? Is there a way that you can change a dynamic column to the static value that was calculated for it? Example the column right now is =D4*$C$294 But I want it to be the value that was calculated from it, so that I can remove one of the columns it is using to calculate the value with. Follow me?

07-09-2004, 02:51 PM	#2
pornstar2pac Omaha Hi/Lo Join Date: Nov 2003 Posts: 17,380	I have the same question __________________ Trump haters gonna hate. that's all they can do

07-09-2004, 03:08 PM	#4
jayeff Confirmed User Join Date: May 2001 Posts: 2,944	Highlight the column --> Ctrl+C: don't move the cursor. Menu bar --> Edit --> Paste Special [select values] --> Okay You can paste the column somewhere else if you want [to be safe]. In that case just put the cursor wherever you want the top of the column to appear. Last edited by jayeff; 07-09-2004 at 03:09 PM..

07-09-2004, 04:09 PM	#7
Calvinguy Confirmed User Join Date: Oct 2002 Location: European Union Posts: 1,752	I use excel for my mysql table info. Can you in some way by a macro make a function that will take the info from some fields and make a SQL query to copy and paste into myphpadmin?

07-09-2004, 04:16 PM	#8
wyldblyss Confirmed User Join Date: Nov 2003 Location: The Buck Starts Here Posts: 5,779	Wow man lovins as a reward! Now is that a good thing or a bad thing?