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?

I have the same question:)

bizump

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.

YAY man love! must be my lucky day!

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?

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

its a great thing ! ;)

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 :thumbsup