Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 5th 05, 05:56 PM
hospital dietitian
 
Posts: n/a
Default How to link rows in Excel so they will stay together during sort?

In Excel I am trying to track body weights over time for hospital patients,
linked with specific interventions on the row below. I would like to link
these 2 rows of data permanently so that when I sort based on intervention,
the body weight data will stay with the intervention.

  #2   Report Post  
Old July 5th 05, 06:30 PM
Jon Peltier
 
Posts: n/a
Default

Excel doesn't work like this. Each row in a list is a distinct record.
Your intervention information should go in the same row as the patient
data, in the sortable database. You could construct a display worksheet
that linked two rows of cells to one row of the data worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


hospital dietitian wrote:

In Excel I am trying to track body weights over time for hospital patients,
linked with specific interventions on the row below. I would like to link
these 2 rows of data permanently so that when I sort based on intervention,
the body weight data will stay with the intervention.

  #3   Report Post  
Old June 30th 10, 04:03 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1
Default

Quote:
Originally Posted by hospital dietitian View Post
In Excel I am trying to track body weights over time for hospital patients,
linked with specific interventions on the row below. I would like to link
these 2 rows of data permanently so that when I sort based on intervention,
the body weight data will stay with the intervention.

I having similar troubles!

my potential solution is to somehow convert the related rows into objects (in my case i have 4-5 rows of 33 columns, and couple of hundred of these 4-row objects). then the sorting would be done by accessing certain attribute of the multi-row object, and have the result displayed in some other format as oppose to having them directly sorted. perhaps graphically or onto another sheet.

the other solution would be stuffing the 4 rows into 1 as the above poster suggested. i think that would be much more doable, but at the cost of being able to sort out certain relationship within the 4 rows.


anyone want to shed more light on how to continue with the first potential solution?


thanks,
guanto
  #4   Report Post  
Old October 5th 10, 05:10 AM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2010
Posts: 19
Default

Quote:
Originally Posted by guanto View Post
I having similar troubles!

my potential solution is to somehow convert the related rows into objects (in my case i have 4-5 rows of 33 columns, and couple of hundred of these 4-row objects). then the sorting would be done by accessing certain attribute of the multi-row object, and have the result displayed in some other format as oppose to having them directly sorted. perhaps graphically or onto another sheet.

the other solution would be stuffing the 4 rows into 1 as the above poster suggested. i think that would be much more doable, but at the cost of being able to sort out certain relationship within the 4 rows.


anyone want to shed more light on how to continue with the first potential solution?


thanks,
guanto

Hi,

New to this forum but far from new to Excel and VBA.

Can assist by automating the conversion of your 4-5 rows into a single row if you really want to go that route.

Would like to suggest an alternative.

Can I assume that not all patients get/suffer(?) every intervention?

With a Macro you can create a report based on a specific intervention.

This would show a baseline and post intervention result, just for the patients having THAT particular intervention.

OR

Can show baseline, and results for all interventions on a patient-by-patient basis.

Happy to assist with this one off-line, as now too specific an issue for most users.

Regards

David

Educo


Reply
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
How do i sort items using two rows per item in Excel? primus4000 Excel Discussion (Misc queries) 1 July 1st 05 12:16 PM
How do I find duplicate rows in a list in Excel, and not delete it Matthew in FL Excel Discussion (Misc queries) 2 June 15th 05 09:11 PM
EXCEL LINK CELL FORMULA MDL2005 Excel Worksheet Functions 3 March 18th 05 01:49 PM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 03:43 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017