Hi,


first time posting here so hopefully this is the right area.

Please see the attached spreadsheet with sample data. What I need to do is the following:

1) only paste data into the first sheet (formatted as already shown in there) and Excel extract data from Sheet 1 to fill in Sheet 2 and Sheet 3

2) Sheet 2 contains only 3 of the 5 columns of Sheet 1: MyIndex, Serial Number and Sales. It is sorted by Sales LOW to HIGH. And next to each Sales cell it has the related Serial Number and MyIndex value.

3) Sheet 3 is the same as Sheet 2 (explained in point 2 above) but: 1) instead of Sales it contains the Revenue column and 2) the Revenue Column is sorted from HIGH to LOW

NOTE: If it helps I can make sure that the data pasted on Sheet 1 is always a known/fixed number of rows

If possible:
- not using extra columns/sheets (but if cannot be avoided then that's ok)
- to do it with formulas and not macros/programming

Many thanks

Attached Files

Book4.xlsx (10.9 KB, 9 views)