is there a way to change formulas to values for sorting purposes?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi!

Select the cells with the formulas.

Edit>Copy then Edit>Paste Special>Values

Biff

"Change formulas to values" <Change formulas to
(e-mail address removed)> wrote in message
news:[email protected]...
 
Hi,

ps, save your Workbook before you play with Macros, and as a differen
name afterwards.

To change the H column to reflect the formula in column B is

For i = 1 To 100
Range("H" & i).Value = "'" & Range("b" & i).Formula
Next i

To put that into a macro, select Tools, Macro, Record new macro,
select a cell, then end the macro recorder.
then, Tools, Macro, Macros, select the macro and Edit.

Copy the code, and amend the For i = 1 to 100 to show the rows wher
you wish this to happen, amend the columns H & B to be where you wan
the formula to show (a spare column) and where the formula was.
Run the macro.

Hope this helps

is there a way to change formulas to values for sorting purposes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Is there a way to change the color 3
Excel Help to copy information from one row at a time to another sheet 1
Sorting into different worksheets from a unique value 12
Advanvnce formula and function 1
Excel Dragging countif formula with changing criteria 3
get that 0 outta there 2
Sorting a protected sheet 1

Back
Top