LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Linked Cells and Sort Issues

Thanks for the assistance. Unfortunately Im not proficient at writing macros
but Ill do some research and give it a try.

"DownThePaint" wrote:

Hi Geraldine;
If you can put the manual inputs into Sheet A and then it will work. If you
cannot do that then you'll have to write a macro that will retrieve the data
from Sheet A and put it into Sheet B plus the sorting.

I hope it helps,


"Geraldine" wrote:

Hi All.

I've created a workbook where a group of cells from one worksheet (worksheet
B) are populated by way of a link to another worksheet (worksheet A).
Worksheet B also has manual input in the column next to the columns that are
linked from worksheet A. When worksheet A gets sorted the manual input in
worksheet B doesn't sort with the other fileds.

How can I make them stay together?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock sets of cells in a row and sort by date linked to each set Rinn1234 Excel Discussion (Misc queries) 0 December 3rd 09 09:24 PM
Font Size Issues in linked tables Muppet Charts and Charting in Excel 1 April 29th 06 11:33 PM
How do I sort linked cells ? karen Excel Discussion (Misc queries) 5 November 12th 05 11:25 PM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
sort 2 or more rows of cells linked to one row of data Magdalena Excel Worksheet Functions 1 July 16th 05 09:43 PM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"