Home | Community | Message Board

NorthSpore.com BOOMR Bag!
This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

PhytoExtractum Shop: Maeng Da Thai Kratom Leaf Powder

Jump to first unread post Pages: 1
InvisibleChinChiller
Male


Registered: 07/03/10
Posts: 3,270
Excel VBA help
    #19126792 - 11/12/13 02:47 PM (10 years, 3 months ago)

I have two data sets with corresponding identification numbers in one column of each set of data (4 or 5 columns on both sides of the spread sheet make up each data set). There are missing ids and duplicates. I need some code to sort both sets according to the corresponding id numbers in two columns, shifting the rows to match eachother.


Extras: Filter Print Post Top
Invisiblememes
Blessed


Folding@home Statistics
Registered: 01/11/05
Posts: 27,785
Loc: In a Tree
Re: Excel VBA help [Re: ChinChiller]
    #19126813 - 11/12/13 02:51 PM (10 years, 3 months ago)

you want to run a Vlookup (I think, guessing from your description).  google how to do it and keep in mind that formatting is everything in getting it to work


Extras: Filter Print Post Top
InvisibleChinChiller
Male


Registered: 07/03/10
Posts: 3,270
Re: Excel VBA help [Re: memes]
    #19126870 - 11/12/13 03:05 PM (10 years, 3 months ago)

I get the vlookup part but actually shifting the data doesnt seem so simple


Extras: Filter Print Post Top
Invisiblepwnasaurus
Stranger
I'm a teapot User Gallery


Registered: 07/16/08
Posts: 12,317
Loc: Canada Flag
Re: Excel VBA help [Re: ChinChiller]
    #19126875 - 11/12/13 03:08 PM (10 years, 3 months ago)

Are you saying that you want to do a sort on the ID column but sort the entire row together?


Extras: Filter Print Post Top
Invisiblememes
Blessed


Folding@home Statistics
Registered: 01/11/05
Posts: 27,785
Loc: In a Tree
Re: Excel VBA help [Re: pwnasaurus]
    #19126890 - 11/12/13 03:12 PM (10 years, 3 months ago)

highlight the top row, hold down alt and then press "D F F" (while holding alt) and it'll make your top row sortable.  then, you can sort as you wish.

Control + C to copy
Alt + E S V (hold alt, press ESV in sequence) to "Paste plain text" wherever you're trying to move it to






again - i'm not sure if this exactly what you need, as i can't see it and can't truly conceptualize your dilemma in my head (sorry, after work, brain turned off)


Extras: Filter Print Post Top
InvisibleChinChiller
Male


Registered: 07/03/10
Posts: 3,270
Re: Excel VBA help [Re: memes]
    #19127249 - 11/12/13 04:20 PM (10 years, 3 months ago)





I have these two sets of data on one spreadsheet. Basically 6,000 student entries in the first picture and some test scores in the second picture. The test scores were selected at random 8 for each classroom, not for every student. They need to be lined up so the student number in column F lines up with the student ID in Column U without messing up the other data, just organizing it.


Extras: Filter Print Post Top
InvisibleChinChiller
Male


Registered: 07/03/10
Posts: 3,270
Re: Excel VBA help [Re: ChinChiller]
    #19127274 - 11/12/13 04:25 PM (10 years, 3 months ago)

I know I could do it with a loop, I just dont have any experience coding in visual basic. Any pointers/help/snidbits of code would be very much appreciated!


Extras: Filter Print Post Top
Invisiblememes
Blessed


Folding@home Statistics
Registered: 01/11/05
Posts: 27,785
Loc: In a Tree
Re: Excel VBA help [Re: ChinChiller]
    #19127390 - 11/12/13 04:47 PM (10 years, 3 months ago)

two sets of data on one spreadsheet?  no wonder your shits all fucked up.



i'd move one block of data over to a new spreadsheet and work with them individually.


Extras: Filter Print Post Top
InvisibleChinChiller
Male


Registered: 07/03/10
Posts: 3,270
Re: Excel VBA help [Re: memes]
    #19127423 - 11/12/13 04:52 PM (10 years, 3 months ago)

Quote:

memes said:
two sets of data on one spreadsheet?  no wonder your shits all fucked up.



i'd move one block of data over to a new spreadsheet and work with them individually.



Would it be easier to do the loop if it was in a different file?


Extras: Filter Print Post Top
Invisiblememes
Blessed


Folding@home Statistics
Registered: 01/11/05
Posts: 27,785
Loc: In a Tree
Re: Excel VBA help [Re: ChinChiller]
    #19127581 - 11/12/13 05:22 PM (10 years, 3 months ago)

glhf man.




sorry :frown:


Extras: Filter Print Post Top
Jump to top Pages: 1

PhytoExtractum Shop: Maeng Da Thai Kratom Leaf Powder


Similar ThreadsPosterViewsRepliesLast post
* Excel/Works Spreadsheet help demiu5 678 6 09/12/06 05:34 PM
by EndlessNameless
* Excel/Access VBA gilesypopper 449 7 04/26/09 07:51 AM
by gilesypopper
* Microsoft Excel help endokrin 431 1 04/28/05 04:35 PM
by afoaf
* excel help please
( 1 2 all )
LethalX5 1,878 31 09/11/05 11:08 AM
by InsatiableThirst
* Excel help plz Platinum 320 6 05/20/09 01:30 PM
by circularvortex
* VBA Help!!! KillerPicklez 476 9 11/18/08 06:36 PM
by KillerPicklez
* excel help please LethalX5 291 1 02/08/08 04:57 PM
by Sell Your Soul
* A spreadsheet I made that works nicely packet_loss 509 2 11/19/09 05:29 AM
by packet_loss

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
446 topic views. 2 members, 44 guests and 50 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.021 seconds spending 0.005 seconds on 12 queries.