Excel question - GoFuckYourself.com

mkx · 11-06-2006, 07:06 PM

Ok here's the situation. I have one sheet with line by line unique items example:

Item Lala Lala2 Lala3
304 Spec Spec Spec
305 Spec Spec Spec
308 Spec Spec Spec
etc

then I have another sheet with repeat items example:

304
304
304
304
304
304
305
305
308
308
308
308

etc.

Is there a quick way of auto filling specs to the multiple item lines based on the information I have on the single item/line sheet? I reckon it will take me a couple hours to do this manually.

mkx · 11-06-2006, 07:19 PM

$5 paypal to anyone who can explain this to me so I can get it done

mkx · 11-06-2006, 07:22 PM

Basically I need to tell it this but I don't know the language

If Z(Sheet1) = A(sheet2), copy and paste B D E and F from Sheet2 to AA AB AC AD and AE on Sheet 1

mkx · 11-06-2006, 07:41 PM

$10 paypal

After Shock Media · 11-06-2006, 07:54 PM

Quote:

Originally Posted by mkx

$10 paypal

That is like 10 days worth of labor in parts of Bangladesh. To bad they do not have computers though.

marketsmart · 11-06-2006, 07:55 PM

bump to help you!

shekinah · 11-06-2006, 08:06 PM

Maybe you highlighted it and you drag it all down that's why it's repeated.

E$_manager · 11-06-2006, 08:18 PM

You had a nice chat with yourself

mkx · 11-06-2006, 08:24 PM

30 more minutes and ill be done

mkx · 11-06-2006, 08:44 PM

And done

psili · 11-06-2006, 08:46 PM

Did you get the VLookup working, or am I off in what you were trying?

mkx · 11-06-2006, 08:56 PM

I did it manually

DjSap · 11-06-2006, 09:15 PM

vlookup would be what you were looking for...remember it for next time...

Mad man · 11-06-2006, 10:29 PM

I hate that program. I seem to move stuff around and run into trouble like you did. I usually look up some info on google. I wouldn't think to ask on gfy.

11-06-2006, 07:06 PM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Excel question Ok here's the situation. I have one sheet with line by line unique items example: Item Lala Lala2 Lala3 304 Spec Spec Spec 305 Spec Spec Spec 308 Spec Spec Spec etc then I have another sheet with repeat items example: 304 304 304 304 304 304 305 305 308 308 308 308 etc. Is there a quick way of auto filling specs to the multiple item lines based on the information I have on the single item/line sheet? I reckon it will take me a couple hours to do this manually.

11-06-2006, 08:06 PM	#7
shekinah Confirmed User Join Date: May 2006 Posts: 8,452	Maybe you highlighted it and you drag it all down that's why it's repeated. __________________ [Web Design \| Development \| Programming \| Content Writing ] ICQ: 238-890-469

11-06-2006, 08:18 PM	#8
E$_manager Too lazy to set a custom title Join Date: Apr 2006 Location: pink adult dreams Posts: 13,557	You had a nice chat with yourself __________________ Enjoy more sales with EnjoyBucks! Homemade: Asian : Ebony : GFs : Voyeur : Nudist : Public : 3D

11-06-2006, 08:46 PM	#11
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	Did you get the VLookup working, or am I off in what you were trying? __________________ Your post count means nothing.

11-06-2006, 09:15 PM	#13
DjSap Confirmed User Join Date: Jul 2002 Posts: 3,869	vlookup would be what you were looking for...remember it for next time... __________________ Blog Themes, TGP Design, Writing Services, Grunt Work ICQ: 66871495

11-06-2006, 07:19 PM	#2
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	$5 paypal to anyone who can explain this to me so I can get it done

11-06-2006, 07:22 PM	#3
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Basically I need to tell it this but I don't know the language If Z(Sheet1) = A(sheet2), copy and paste B D E and F from Sheet2 to AA AB AC AD and AE on Sheet 1

11-06-2006, 07:41 PM	#4
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	$10 paypal

11-06-2006, 07:55 PM	#6
marketsmart HOMICIDAL TROLL KILLER Industry Role: Join Date: Dec 2004 Location: Sunnybrook Institution for the Criminally Insane Posts: 20,419	bump to help you!

11-06-2006, 08:24 PM	#9
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	30 more minutes and ill be done

11-06-2006, 08:44 PM	#10
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	And done

11-06-2006, 08:56 PM	#12
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	I did it manually

11-06-2006, 10:29 PM	#14
Mad man Confirmed User Join Date: Sep 2006 Posts: 109	I hate that program. I seem to move stuff around and run into trouble like you did. I usually look up some info on google. I wouldn't think to ask on gfy. __________________ http://www.maddiestyle.com Contact Me (link trades) - maddmail/at/maddiestyle.com Starter webhosting - use dreamhost (Sign up here) Right now I’m recommending (moneytree live cams Sign up here)