Formulas not allowing proper sorting

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.
 
B

BrianB

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
 
M

Mark Graesser

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.
 
L

Lib

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.
 

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

Combining two sheets of data into one and sorting by value - using macros 5
Creating a template that I can reproduce every month by keying ininformation from SAP 8
List all tables, including document structure 0
Duplication 2
Excel Formula or VBA Code 2
Using a vlookup to search multiple criteria for one result? 7
Formula not working properly 2
Need a proper guru! My head hurts ;( 1

Top