LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Need help with sort function and lots of data?

I have an Excel spreadsheets with various data. Lots of Names, Dates, and
information on various things.

I want to edited it so that the contents dont become insensible
if a sort function is applied.

It is hard for me to explain, so I will show what data I have
for example

Date To From Description attached
doc Find it

5/3/2009 Paul Row Bev Hardue cover letter CHIS 199
c://ethos
2/2/2008 Paul Row John Newman PHD paper CHIS 299 c://PHD
4/8/2009 Grant Stow McMan Son Confid. agree CACL 110 d://confi
9/8/2009 Paul Row Bev Hardue Assistant pos ASSGN9 c://ethos
9/8/2009 Sean Briss Bev Hardue cover letter CHIS 199
c://ethos
Resignation
CODE R e://cr/..
Acceptance
form FORM29 d://forms
Chapter sub
REG519 s://ffspdfs

As you can see there are data. and the last 3 dont have a date to or from,
because someone was lazy and didnt add it. So the last 3 should have 9/8/2009
Sean Briss Bev Hardue before each of them but they dont.

So I wanted to copy and paste or fill. But was wondering if it would affect
the sort. And preferably I wouldnt like to. Because if I would like to sort
it with date, I dont want 20 different rows with the same dates. If you
understant.
Is there a way to be able to sort horizontally so the data arent affected
vertically so each row stays together.

And also, MY MAIN QUESTION, what do I do such that if I want to sort the
data, for example the one illustrated above (my data has lots of things
missing, but you can easliy copy past it, but I'd rather not ). How do I do
so the data can be grouped together when sorted. I tried the grouping
function, but that is hopeless! Everything gets messed up.

Can soemone help me please!
Thanks
 
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 link lots of data in multiple worksheets ALSEGUY Excel Worksheet Functions 2 March 17th 06 09:31 PM
How to handle lots of data coa01gsb Charts and Charting in Excel 1 February 20th 06 06:12 PM
lots of data lwm11 Excel Discussion (Misc queries) 2 May 13th 05 07:31 PM
hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. KimSingh Excel Discussion (Misc queries) 2 March 21st 05 07:04 PM
Sorting lots of data miss lynar Excel Discussion (Misc queries) 1 December 16th 04 08:16 PM


All times are GMT +1. The time now is 08:32 PM.

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

About Us

"It's about Microsoft Excel"