Menu
Forums
New posts
Search forums
Calendar
Monthly
Weekly
Agenda
Archive
What's new
New posts
New media
New media comments
New profile posts
Latest activity
Media
New media
New comments
Search media
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles and first posts only
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Help Support Hardline Crawlers :
Forums
Rock Crawling Forums
General Discussion
Excel gurus---HELP
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Welderd" data-source="post: 30171" data-attributes="member: 144"><p>use macros too - this is a great time to learn new skills and it's really handy once you know some tricks</p><p></p><p>show your Visual basics tool bar</p><p>On it there will be a play, record and editor buttons, plus others</p><p></p><p>A real simple way to learn to do things is to hit record - do what you want to do then hit stop - hit the editor and you'll see what it recorded and how it wrote it in visual basic code. You can then assign a shortcut key to it like CTRL + FU or whatever and any time you hit that those buttons it will do what ever is in the code.</p><p></p><p>Once you get good you can have it search cells, find the end of data, sort, add cells, add formulas, make new sheets and even run programs from your excel sheets </p><p></p><p>These are the buttons I was telling you about at Disney - make a few of them and show your boss only a select few to show how productive you are then save the rest for makin your work take no time.</p><p></p><p>I can send you some examples and/or ask around the office for people that have some made. Use them and investigate the code then steal it for your own use, you'll find some neat things you can do and better faster ways to do it. I can write a code to format a bunch of sheets many different ways, you can make it to update your screen so it shows your doing something and it takes a long time or you can just get it done - both are helpful in their own right</p><p></p><p>Never exceed their expectations - or they'll expect it</p><p>perception is the name of the game - not work quality</p></blockquote><p></p>
[QUOTE="Welderd, post: 30171, member: 144"] use macros too - this is a great time to learn new skills and it's really handy once you know some tricks show your Visual basics tool bar On it there will be a play, record and editor buttons, plus others A real simple way to learn to do things is to hit record - do what you want to do then hit stop - hit the editor and you'll see what it recorded and how it wrote it in visual basic code. You can then assign a shortcut key to it like CTRL + FU or whatever and any time you hit that those buttons it will do what ever is in the code. Once you get good you can have it search cells, find the end of data, sort, add cells, add formulas, make new sheets and even run programs from your excel sheets These are the buttons I was telling you about at Disney - make a few of them and show your boss only a select few to show how productive you are then save the rest for makin your work take no time. I can send you some examples and/or ask around the office for people that have some made. Use them and investigate the code then steal it for your own use, you'll find some neat things you can do and better faster ways to do it. I can write a code to format a bunch of sheets many different ways, you can make it to update your screen so it shows your doing something and it takes a long time or you can just get it done - both are helpful in their own right Never exceed their expectations - or they'll expect it perception is the name of the game - not work quality [/QUOTE]
Insert quotes…
Verification
Post reply
Latest posts
I am moving to Tennessee
Latest: Blackbeard
Yesterday at 4:06 PM
General Discussion
For Sale
2005 Ford Excursion Eddie Bauer
Latest: jeeptj99
Monday at 11:55 AM
Vehicles For Sale
I.w.i.w clampy
Latest: bobbedrunner99
Friday at 4:44 PM
Tech & Fab
Salvage 10
Latest: ridered3
Friday at 7:47 AM
Tech & Fab
Ultra4 - Battle in Bluegrass (Bowling Green, KY) East Series (4/19-4/20)
Latest: ridered3
Apr 25, 2024
Trail Rides & Competitions
Forums
Rock Crawling Forums
General Discussion
Excel gurus---HELP
Top