Share via

Sorting excel cells containing vlookups

Anonymous
2015-06-24T20:35:22+00:00

Hi

I am using vlookup to fill in the cells below. It is pulling information from another sheet which changes every time new information is pasted into it. My Pay Code column contains a mix of numbers and letters and I would like to know if I can sort each data set from a-z by the pay code, and have this update when new information is pulled in. I have about 4 data sets total on the same sheet so I dont want to sort the entire column from a-z, only each data set. Does anyone have any suggestions? Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-06-25T00:51:18+00:00

Re:  sorting portions of a worksheet containing formulas

Sorting a worksheet containing formulas usually produces unsatisfactory results.

Formula cell references can change, when sorted, invalidating your worksheet.

You can copy and paste values on to another sheet and then sort the other sheet.

That could be done manually or with VBA programming code.

The code solution would require an evalution of the worksheet complexity and your particular needs.  Some at this forum might attempt it for you - I expect you will have to pay someone to do it.  (not me, I don't hire out anymore)

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest