Since announcing my FREE workshop Introduction to Excel-VB Automation on Monday, which is to hold tomorrow (Sat 19th Mar 2016) for members of my Excel-VB club, I’ve had some MS Excel business users contact me.
In this article I share screenshots and excerpts s from 2 such exchanges – one with a business user based in India, and another with a Nigerian Farm CEO – with background in corporate management – who is a member of my Cost-Saving Farm Business Ideas Club.
A. At about 12:53 p.m on Tuesday 15th March 2016, I got the message below from an Indian gentleman, requesting my help with getting Excel-VB code he was writing to run – trouble free – for a task he was trying to automate.
Here’s the message:
“Sir right now i got vba code for i have been searching from a gengleman…..but can we set two macro in a single excel sheet… The following code solved my Single problem.
Sub Copy_Paste_Data()
Sheets(“Sheet1”).Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
I shall use the above code when I have to export all all kind of data from A3 to N1000.
But If I don’t want to export the data having no value in column I.
If Column I has no value so that row will not be exported to Sheet2… What I mean to say that if I need all data to export then I shall use the above code and When I need to export data having value in column I then I shall use that code for i am requesting you to make.
So this way my grave problem will be solved……….please send me it to my maild id (removed for privacy)
I replied that I would do what he asked on the condition that he agree to let me use him/his “project” as a case study for step-by-step video tutorial I would share with my Excel-VB club members – who pay to learn from me.
He responded by sending a request to join my Excel-VB Club, and posting this follow up message:
It’s your kindness. Thanks for helping me……..Sir I shall eagerly be waiting for your mail with video sir………Thanks a lot again sir..
….Sir, I got formula as I needed. but as we run that, it export the data
even with value (formula also exported and that looks #REF! ). so only
this problem remains now…….so please help this way now i am just
providing you this code that i recently got from a gentleman….Sub Copy_Paste_Filter()
With Sheets(“Sheet1”)
.Range(“I3:I1000″).AutoFilter Field:=1, Criteria1:=”0”
.Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)
.Range(“I3:I1000”).AutoFilter
End WithEnd Sub
The above message came in a 4:29a.m – I’d only just gone to bed 1.5 hours before then, after finishing work on a client project.
So, when I saw it in the morning, I wrote back saying(in part):
“… I am just waking up…My priority this morning is to get a client’s boolk manuscript proof reading finished and returned to him…Only after that will I then be able to spend time creating the video tutorial I offered for use as a case study…If you cannot wait for that, I recommend you ask the “gentleman” that is giving you these codes to help you debug it to get it running properly. Alternatively Google to one of many open discussion forums and post your question there.
My Excel Heaven brand does NOT operate in that manner…When I’m done, I will create the promised video and send to you and my club members. “
He replied saying he would wait.
Looking back, I’m glad I was frank with him, because as I type these words, I still have to do a visit to the talk venue his p.m and also review material I’m to use tomorrow!
So, chances are good that I’ll have to create the promised video over the weekend.
One thing is certain though…
This exercise is going to be perfect for use in explaining how range objects can be manipulated using MS Excel-VB coding. Even more important, this particular case study will serve as an introduction to EFFICIENT coding that executes faster compared to he clumsy code sentences generated by the Macro Recorder (which my club members are starting with)!
B. It’s now confirmed that I’ll be having more than ONE run of my 4 hour FREE talk event tomorrow. Reason: Some members of my Excel-VB club will not be able to make it down to join the main group from 2p.m.
Apart from those wanting to come at a different time (I told them I’d be HAPPY to meet ANY who chose to do so), at least ONE, based outside Lagos will not be able to come down at all.
For him and others like him, the nature of my Excel-VB club makes it possible to STILL learn ALL they need to know.
See details below, based on a response I made to a member of my Cost-Saving Farm Business Ideas club, living in Ibadan, who asked about Video tutorials:
It so happens that my Excel-VB club is designed to enable business users/busy persons who become members learn from me remotely, with the option of attending the FREE Monthly Workshop (Saturday’s being the maiden one).
Since they signed up, the current members have been receiving downloadable video tutorials taking them though what they need to know.
One member who is based in Port Harcourt, chose to purchase the Home Study video tutorials I’m creating on DVD. After the workshop on Saturday, I will add new videos based on that event’s outcome and send to him via Fedex.
I recommend you also join the club, so you can get the DVD via the 2-in-1 offer I make to new members i.e. pay the membership fee to join the club, in response to an offer I make to you via email, and I will send you the DVD containing the home study step-by-step videos, while you continue, like other members, receiving the online tutorials and tips I send out weekly.
Here are some useful links to give you a better idea of what is on offer:
1. LEARN MS EXCEL-VB AUTOMATION FROM ME…IN THE COMFORT OF YOUR HOME!
http://excelheaven.tayosolagbade.com/?page_id=66
2. Learn more about what you get on the DVD below:
Title: Get My Home Study Excel-VB Programming Video Tutorial DVD
URL: http://excelheaven.tayosolagbade.com/?p=336
3. This page provides a detailed background (including a 9 part slide show presentation) about my Excel-VB Club and Competition:
Title: Welcome to my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]
URL: http://excelheaven.tayosolagbade.com/?p=318
RELATED RESOURCE
1 Hour Talk(No. 5): Proven Strategies for Using MS Excel to Boost Employee and Company Productivity (or go to http://tinyurl.com/xlvb1hourtalk)
Click here to contact me if you have any questions or require clarification.
You’re reading Conversations About Productivity Boosting Excel Visual Basic Automation [True Stories: Enquiries from a business user in India and Nigeria] by Tayo Solagbade, originally posted on his Daily Self-Development (SD) Nuggets™ blog. If you loved reading this post, be sure to follow Tayo on Twitter, Facebook, and Google+.
You may also wish to check out his growing library of tutorial and demonstration videos on Youtube. Click here, to download over 10 resources to boost your personal and work related productivity.
IMPORTANT NOTE:
On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), was taken over by Aplus.net. Within a few days however, Tayo used his advanced self-taught web development skills to build (and move his website contents into) a SUPERIOR “reincarnation” at http://www.tayosolagbade.com.
Most URLs bearing the old domain name appearing in search engines should now work if “spontaneousdevelopment.com” is replaced with “tayosolagbade.com”. If you experience any difficulties finding a page or document, email Tayo at tksola dot com.
Click “Tayo, What Happened to SpontaneousDevelopmentDotCom?” to read a detailed narrative about how the above event occurred :-))
Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:
Succeed by Emerging from Adversity Like a Phoenix (TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)
And he wrote the one below, to explain why losing a domain name, no matter how old NO LONGER determines your online success or otherwise:
A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
Source: ExcelVB
