Make $10! Ask me how (Excel / Visual Basic Related)

[Flipx99 5,000+ posts]

If you work in excel daily, something you may work with is Macros. It is great to oraganize data that is similar every day...and reduces mundance tasks.

One thing I cannot figure out how to do with marcos is this:

Let's say you have 10 columns, and column A -> J

And all the data in columns B - J are tied to column A.

However, column A changes (is grouped together but still changes, thing of it like a category) and at each change in column A, the data is put into a new tab.

Currently, everything is formatted, but we must manually move all the column A's to seperate tabs.

In my mind, there is a function that seems like

With change in (A), highlight, move, tab (B), etc.

Getting VB to recognize the changes in column A is where I am having difficulty.

-------

For $5 getting excel to recognize "Last"....as the last column and row are junk info...getting the macro to delete this will be nice.

Payment will be rendered at 10:00 CST tonight, providing I can get it to work.

Click to read more...

 

[Pl8er 5,000+ posts]

I'll ask. One of my buddies is a systems analyst for kraft, this is what he does.

And fuck your money

 

[Flipx99 5,000+ posts]

werd....you are doing your country a service!

 

[snoopdan 5,000+ posts]

I really didnt read nor think thru your issue, but have you tried posting your question on that big excel forum? them dudes on there like smoke crack and come up with equasions on the fly. Ive had to go there before when I needed something funky.

 

[_DjScrew_ 5,000+ posts]

I never got that into excel, but it's definatly powerful.http://www.metacafe.com/watch/308907/hidden_3d_game_in_excel/

 

[fbi90909 5,000+ posts]

I never got that into excel, but it's definatly powerful.http://www.metacafe.com/watch/308907/hidden_3d_game_in_excel/

on a work computer and a little sketchy on doing that.. anyone know what it does?

 

[_DjScrew_ 5,000+ posts]

on a work computer and a little sketchy on doing that.. anyone know what it does?

It's just a hidden game. Google "excel hidden game" http://www.ehow.com/how_2049779_find-hidden-game-excel-2000.html

 

[Flipx99 5,000+ posts]

I really didnt read nor think thru your issue, but have you tried posting your question on that big excel forum? them dudes on there like smoke crack and come up with equasions on the fly. Ive had to go there before when I needed something funky.

I see. I don't frequent any forum besides this one. I may work on that at home. I don't want to be seen forum hopping from NCC.

 

[snoopdan 5,000+ posts]

on a work computer and a little sketchy on doing that.. anyone know what it does?

Is it that little video game for excel ? Its quite banned on military computers, and im pretty sure Flip is on one of those.

 

[snoopdan 5,000+ posts]

I see. I don't frequent any forum besides this one. I may work on that at home. I don't want to be seen forum hopping from NCC.

:shrug: if its for your job then id say its within the scope of AUP.

 

[crunktimes.com 5,000+ posts]

Has anyone seen the game? Office 2007 here //content.invisioncic.com/y282845/emoticons/frown.gif.a3531fa0534503350665a1e957861287.gif I may have to find a friend in a third-world country to find a copy of 2000.

 

[Flipx99 5,000+ posts]

:shrug: if its for your job then id say its within the scope of AUP.

Not forums...hell, not sure how I am allowed to post here

 

[JimJ 5,000+ posts]

For $5 getting excel to recognize "Last"....as the last column and row are junk info...getting the macro to delete this will be nice.

That's easy. http://www.ozgrid.com/VBA/ExcelRanges.htm

I never messed with creating new tabs before, but I'm sure there's a predefined function in VBA that does that for you. I sold my big VBA reference book when I finished that class, though, sorry //content.invisioncic.com/y282845/emoticons/biggrin.gif.d71a5d36fcbab170f2364c9f2e3946cb.gif

Wait a second...I'm dumb...did you mean you wanted to put that data into another worksheet? You can add a worksheet using something like Sheets.Add.Name ="new sheet name"

 

[Flipx99 5,000+ posts]

That's easy. http://www.ozgrid.com/VBA/ExcelRanges.htm
I never messed with creating new tabs before, but I'm sure there's a predefined function in VBA that does that for you. I sold my big VBA reference book when I finished that class, though, sorry //content.invisioncic.com/y282845/emoticons/biggrin.gif.d71a5d36fcbab170f2364c9f2e3946cb.gif

Creating the new tabs is easy....

The issue is getting the macro to recognize (a) the changes in column A and (b) to move them into that tab.

 

[fbi90909 5,000+ posts]

:/

i have excel 2003