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

[Chevillac 5,000+ posts]

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.

hmmmm, and youve already got the extract function there? youre just trying to make it automated each time a change is made. I dont think Im understanding the question. Maybe im just a dumbass.

 

[Flipx99 5,000+ posts]

hmmmm, and youve already got the extract function there? youre just trying to make it automated each time a change is made. I dont think Im understanding the question. Maybe im just a dumbass.

You can use the recorder to create and label the new tabs....you don't have to know the code.

If I could figure out how to make excel "group" like items in category A, I can move them to different tabs.

 

[Pl8er 5,000+ posts]

Well he replied back but this is what he said

I would need to see the spreadsheet to determine the logic that would be used. The code has to be specific to the data type and data held in the cells to be sorted. So it takes a few minutes to develop a game plan before writing any code. No biggie thou.

If you want me to see what your working on, no biggie pm me and I'll tell you my email. But I believe you work for the gov't and that wouldn't be the best of ideas //content.invisioncic.com/y282845/emoticons/wink.gif.608e3ea05f1a9f98611af0861652f8fb.gif

 

[Flipx99 5,000+ posts]

Yes, I couldn't send the exact S/S...for sure. But I can try to invent something without any info to see if he could get it to work.

I see where he's coming from and it makes sense.

 

[Flipx99 5,000+ posts]

Thanks for that though.

 

[Pl8er 5,000+ posts]

Send it if you like. He builds insane sheets.