Zilvia.net Forums | Nissan 240SX (Silvia) and Z (Fairlady) Car Forum

Go Back   Zilvia.net Forums | Nissan 240SX (Silvia) and Z (Fairlady) Car Forum > Specific Topics > Off Topic Chat

Off Topic Chat All non related chat goes here.


Reply
 
Thread Tools Display Modes
Old 08-16-2011, 09:44 PM   #1
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Need Help. Any Excel experts here??

I have question about creating Macro with comparing 2 sheets...
let me know if you are an expert of Excel..

Thanks !
K_style is offline   Reply With Quote
Sponsored Links
Old 08-17-2011, 08:50 AM   #2
0wn3r
Zilvia Addict
 
0wn3r's Avatar
 
Join Date: Oct 2007
Location: CT
Posts: 676
Trader Rating: (4)
0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of
Feedback Score: 4 reviews
The only thing I don't know how to do in Excel is macros..which I'm sure aren't hard it's just that I've never tried. I can do almost everything I need to with formulas.
__________________
97 240sx se
0wn3r is offline   Reply With Quote
Old 08-17-2011, 09:12 AM   #3
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by 0wn3r View Post
The only thing I don't know how to do in Excel is macros..which I'm sure aren't hard it's just that I've never tried. I can do almost everything I need to with formulas.
Then let me ask you this..

I have sheet1 and sheet2, contains pretty much same everything but few cells with different values. I want to compare those two sheets and highlight the differences. no calculation just simple comparison.

I wanted to do Conditional Formatting but it won't allow to do in with different worksheet.

I googled it and came up with VBA code to make that happen but I want to know if there is other way.
K_style is offline   Reply With Quote
Old 08-17-2011, 09:39 AM   #4
blueshark123
Post Whore!
 
blueshark123's Avatar
 
Join Date: Apr 2006
Location: North Jersey
Posts: 5,481
Trader Rating: (55)
blueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant future
Feedback Score: 55 reviews
I knew a girl that they asked her if she knew how to create macro in excel on a interview she went on is lol she didnt end up with the job to say the least
blueshark123 is offline   Reply With Quote
Old 08-17-2011, 09:41 AM   #5
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by blueshark123 View Post
I knew a girl that they asked her if she knew how to create macro in excel on a interview she went on is lol she didnt end up with the job to say the least
haha... LOL

I am in same position.. it is a test for new job.. I know how to create Macro but this is a very complicate situation I am in..
If I had MS excel 2010, I could compare two difference worksheet with Conditional formatting + making new rules" but this ancient excel 2003 won't let me do it, either 2007.
Thanks !
K_style is offline   Reply With Quote
Old 08-17-2011, 09:46 AM   #6
blueshark123
Post Whore!
 
blueshark123's Avatar
 
Join Date: Apr 2006
Location: North Jersey
Posts: 5,481
Trader Rating: (55)
blueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant future
Feedback Score: 55 reviews
Quote:
Originally Posted by K_style View Post
haha... LOL

I am in same position.. it is a test for new job.. I know how to create Macro but this is a very complicate situation I am in..
If I had MS excel 2010, I could compare two difference worksheet with Conditional formatting + making new rules" but this ancient excel 2003 won't let me do it either 2007.
Thanks !
tell them to upgrade that shit lol
blueshark123 is offline   Reply With Quote
Old 08-17-2011, 09:48 AM   #7
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by blueshark123 View Post
tell them to upgrade that shit lol
Tell... who ? my future employer ??? LOL
K_style is offline   Reply With Quote
Old 08-17-2011, 11:33 AM   #8
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Arrrghh !!!! Fu*k excel 2003 and 2007 !!!
K_style is offline   Reply With Quote
Old 08-17-2011, 11:52 AM   #9
axiomatik
Post Whore!
 
axiomatik's Avatar
 
Join Date: Dec 2003
Location: ATL
Posts: 4,697
Trader Rating: (0)
axiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfectionaxiomatik is close to perfection
Feedback Score: 0 reviews
Why can't you create a section of worksheet 1 that is simply equal to worksheet 2, and then use conditional formatting between the two sections?
__________________
axiomatik is offline   Reply With Quote
Old 08-17-2011, 12:01 PM   #10
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by axiomatik View Post
Why can't you create a section of worksheet 1 that is simply equal to worksheet 2, and then use conditional formatting between the two sections?
Because it is a test that I have to do without copying sheet2 to sheet1's table..

so sad. isn't it?
K_style is offline   Reply With Quote
Old 08-17-2011, 12:15 PM   #11
blueshark123
Post Whore!
 
blueshark123's Avatar
 
Join Date: Apr 2006
Location: North Jersey
Posts: 5,481
Trader Rating: (55)
blueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant futureblueshark123 has a brilliant future
Feedback Score: 55 reviews
Ill ask my brother if he can help since he went to school for computer science and knows excel well
blueshark123 is offline   Reply With Quote
Old 08-17-2011, 01:41 PM   #12
0wn3r
Zilvia Addict
 
0wn3r's Avatar
 
Join Date: Oct 2007
Location: CT
Posts: 676
Trader Rating: (4)
0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of
Feedback Score: 4 reviews
They should give me the job because I can do it.
__________________
97 240sx se
0wn3r is offline   Reply With Quote
Old 08-17-2011, 02:11 PM   #13
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by 0wn3r View Post
They should give me the job because I can do it.
Ok I will ask them...

could you explain how you would do it?
K_style is offline   Reply With Quote
Old 08-17-2011, 02:12 PM   #14
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
I pretty much wrote VBA code to do it but, I am still trying to figure out how I could do it using Excel feature
K_style is offline   Reply With Quote
Old 08-17-2011, 03:18 PM   #15
0wn3r
Zilvia Addict
 
0wn3r's Avatar
 
Join Date: Oct 2007
Location: CT
Posts: 676
Trader Rating: (4)
0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of
Feedback Score: 4 reviews
Fine, but if you get the job just send half of your first year's salary into my paypal. kthx.

Excel is an exceptionally amazing tool that also blows. This is one of the rare times in Excel that you need to setup a table for your data (know how to do that?). Now, without having a damn clue what data you're comparing between the two sheets I'll just make an example...

Say you have this in Sheet 1:

A1: A, B1: 1
A2: B, B2: 2
A3: C, B3: 3

Now in Sheet 2 you have:

A1: A, B1: 1
A2: C, B2: 257
A3: B, B3: 2

From what I've gathered, you want to say in one of those sheets that "Hey, the data in Sheet 1 shows that the value "C" in column A has text/value of "3" in column B. However in Sheet 2 "C" actually has a text/value of "257", then highlight the cell that's different.

I guess it doesn't matter wtf you want to highlight with the conditional formatting, but let's say you want to highlight the value/text of "3" in Sheet 1 to say that it doesn't align with the value of "257" in the other.

You're going to want to set up a table with the data. So on Sheet 2 highlight everything from A1 through B3 and give it a name (to the left of the function button)...let's say you call it "KStylesData" If you expect the sheet to grow in size of the records or data, then I'd play it safe and pick something much further down than B3 (like B100 or something).

After you've defined a range with a name/table, then go back to Sheet 1 and go into your Format > Conditional Formatting option.

In the drop down, select "Formula Is...". In the field to the right of that, you're going to input a formula. This is the dumb confusing part here that's causing you an issue because you can't use a reference to other sheets than the one you're already in, so that's why you create a table. It will say:

=NOT(B1=(vlookup(A1,KStylesData,2,false)))=TRUE

So in case you need it, what the formula is saying is "If the text/value in cell B1 is NOT equal to the text/value of what you're going to lookup in the KystlesData table which happens to be in Sheet2, get me the 2nd column's text/value and put in a conditional format if they are not the same. If they WERE the same, it would return a FALSE and you can make another conditonal format for that if you wanted. Let's say you pick a red font for something that doesn't equal and you had put that conditional formatting like I said in Sheet 1 column B. You should see is something like this:

Sheet 1:

A1: A, B1: 1
A2: B, B2: 2
A3: C, B3: 3

Sheet 2:

A1: A, B1: 1
A2: C, B2: 257
A3: B, B3: 2

...because A = 1 on both sheets, B = 2 on both sheets, but C = 3 on Sheet1 while C = 257 on Sheet2. So your conditional formatting in Sheet1 column B highlights that cell in red.

Skippy dude yo. That make sense?

p.s. On a normal vlookup I usually recommend avoiding using a table like that. This is an exception. You'll typically want to use entire columns. So rather than vlookup(A1,KyStylesData,2,false) you'd put in vlookup(A1,Sheet2!A:B,2,false). Last I checked Excel's help section says to use a table name which is a load of crap. Using entire columns allows you to add or remove data in column A and B as you see fit without having to modify the range.

Also, I don't think that conditional formatting has a check on your formula to say whether or not you typed it in wrong like it normally would. So if you hit ok and it doesn't work like you thought it should, DOUBLE CHECK what you typed in because I'm pretty sure it will allow almost anything...except for referencing other sheets of course :P You could probably get away with using a COUNTIF if you wanted to instead, but I usually prefer the functionality of vlookups if I have a choice.
__________________
97 240sx se
0wn3r is offline   Reply With Quote
Old 08-17-2011, 04:28 PM   #16
LimeLite Racing
Post Whore!
 
LimeLite Racing's Avatar
 
Join Date: May 2007
Location: Eugene!
Posts: 3,197
Trader Rating: (24)
LimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfection
Feedback Score: 24 reviews
Wtf? You're getting ANOTHER job?! Lol you da man.
__________________
Drift.
LimeLite Racing is offline   Reply With Quote
Old 08-17-2011, 04:37 PM   #17
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by LimeLite Racing View Post
Wtf? You're getting ANOTHER job?! Lol you da man.
Upgrading within company... LOL



I am working on VBA.... I will take a look at the Vlookup way you told me..
K_style is offline   Reply With Quote
Old 08-17-2011, 04:38 PM   #18
LimeLite Racing
Post Whore!
 
LimeLite Racing's Avatar
 
Join Date: May 2007
Location: Eugene!
Posts: 3,197
Trader Rating: (24)
LimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfection
Feedback Score: 24 reviews
Oh nice!!! How are you liking it over there?
__________________
Drift.
LimeLite Racing is offline   Reply With Quote
Old 08-17-2011, 04:38 PM   #19
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by LimeLite Racing View Post
Wtf? You're getting ANOTHER job?! Lol you da man.
BTW.... how come you never call me...

I am so~ thirsty with beer these days... dont you miss "Ruby~nator"??
K_style is offline   Reply With Quote
Old 08-17-2011, 04:40 PM   #20
LimeLite Racing
Post Whore!
 
LimeLite Racing's Avatar
 
Join Date: May 2007
Location: Eugene!
Posts: 3,197
Trader Rating: (24)
LimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfection
Feedback Score: 24 reviews
Hahaha sorry man! Just busy at work I swear we're gonna go grab beers in the very near future. Like tomorrow afternoon maybe? Yes I definitely miss the rubinator!!!!!!!!!! Hahaha
__________________
Drift.
LimeLite Racing is offline   Reply With Quote
Old 08-17-2011, 04:41 PM   #21
LimeLite Racing
Post Whore!
 
LimeLite Racing's Avatar
 
Join Date: May 2007
Location: Eugene!
Posts: 3,197
Trader Rating: (24)
LimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfectionLimeLite Racing is close to perfection
Feedback Score: 24 reviews
If you're off tomorrow I'd be down to max it to downtown Mcminnies if you want.
__________________
Drift.
LimeLite Racing is offline   Reply With Quote
Old 08-17-2011, 05:08 PM   #22
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by LimeLite Racing View Post
If you're off tomorrow I'd be down to max it to downtown Mcminnies if you want.
all the way to Downtown?? Imbrie hall one is nice too
K_style is offline   Reply With Quote
Old 08-17-2011, 08:51 PM   #23
0wn3r
Zilvia Addict
 
0wn3r's Avatar
 
Join Date: Oct 2007
Location: CT
Posts: 676
Trader Rating: (4)
0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of0wn3r has much to be proud of
Feedback Score: 4 reviews
Quote:
Originally Posted by K_style View Post
I am working on VBA.... I will take a look at the Vlookup way you told me..
What I did there takes about 5 seconds to do in Excel...but ok. ...keep trying to go the VBA route I guess. Macro completely unecessary.

And you're welcome.
__________________
97 240sx se
0wn3r is offline   Reply With Quote
Old 08-17-2011, 11:22 PM   #24
K_style
Post Whore!
 
K_style's Avatar
 
Join Date: Dec 2007
Location: Henderson, NV
Posts: 7,666
Trader Rating: (63)
K_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfectionK_style is close to perfection
Feedback Score: 63 reviews
Quote:
Originally Posted by 0wn3r View Post
What I did there takes about 5 seconds to do in Excel...but ok. ...keep trying to go the VBA route I guess. Macro completely unecessary.

And you're welcome.
Oh yes, of course...
Thank you and thank you for your effort and help.
I have to create Macro either write VBA code or record Macro with using formula. that was a task..
K_style is offline   Reply With Quote
Reply

Bookmarks


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 04:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
vB.Sponsors
Copyright © 1998 - 2019, Zilvia.net™