Formulas not allowing proper sorting

  • Thread starter Thread starter Lib
  • Start date Start date
L

Lib

I have information in groups of 3 on 5 different sheets
that I need copied to one sheet and sorted in decending
order. Some formulas on one sheet are the same as another
sheet and I think there is a conflict there. I have tried
to copy and paste then sort but I get a different result
each time. I would like this to be done automatically.
This is a huge file and I can send it to make it easier to
see what I mean.
 
Your method of pasting to a single sheet seems to be OK in principle
pobably Paste Special .. Values would solve the problem.

This could be a case where you are really starting in the wrong place
It is usually far easier to start from a table format of data an
produce reports from that. Excel contains numerous functions and Pivo
Tables to dothe job
 
For this to be done automatically you will probably need to use Visual Basic. However, for your sorting problem, instead of pasting the formulas, use Edit>Paste_Special>Values. This will eliminate the formulas and paste the actual values. Sorting on formulas can cause a lot of unwanted changes in where the formulas point to.

Good Luck,
Mark Graesser

----- Lib wrote: -----

I have information in groups of 3 on 5 different sheets
that I need copied to one sheet and sorted in decending
order. Some formulas on one sheet are the same as another
sheet and I think there is a conflict there. I have tried
to copy and paste then sort but I get a different result
each time. I would like this to be done automatically.
This is a huge file and I can send it to make it easier to
see what I mean.
 
Can someone help me write the code for this?
-----Original Message-----
For this to be done automatically you will probably need
Click to expand...
to use Visual Basic. However, for your sorting problem,
instead of pasting the formulas, use
Edit>Paste_Special>Values. This will eliminate the
formulas and paste the actual values. Sorting on formulas
can cause a lot of unwanted changes in where the formulas
point to.
 
Back
Top