Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock sets of cells in a row and sort by date linked to each set | Excel Discussion (Misc queries) | |||
Font Size Issues in linked tables | Charts and Charting in Excel | |||
How do I sort linked cells ? | Excel Discussion (Misc queries) | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions |