Problem created by sorting linked sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I have a sheet (Sheet 2), that pulls cells through from another sheet
(Sheet 1) and uses the Uniquevalues function. I then have unlinked blank
cells that i enter data in seperately, but is info for the names in the
linked cells. When i use sort on sheet 1, cells A1:A3 move together, i need
A4 to move with them, is this possible?

Example of Sheet 2
| Info from sheet 1 |
A1 A2 A3 A4
Name Ref No Date Blank Cell

Thanks

Becks
 
yes,when you select your cells to sort make sure you select your blank cells
too
 
Wish it was that simple!
The information that is sorted is on sheet 1, therefor the data on sheet 2
which is pulled through from sheet 1 moves as well. I want other cells in
the row that aren't linked to sheet 1 to move as well?
 
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

How to update data from multiple sheets to one specific sheets 4
Filtering of data in a master excel sheet from multiple sheets 3
Sorting problem 6
Look up data from one sheet 1
Populate Data from Summary Sheet 5
Blank Cell Reference, without if statement 4
hyperlink 1
Transfer entire row to another sheet 4

Back
Top