Hi Jon, I just watched your first video. I am a beginner, pretty much, in Excel.I am going to see if I can pick up some of this trough your videos but I have a minor handicap. I am deaf and I was wondering if you have any kind of printed instructions I could get to go with each video/ Thanks for a great video.

Hi Jon, I have a workbook that includes about 20 worksheets. It’s a quoting spreadsheet and I may only use 3 – 4 of the worksheets. I would like to write a macro that would delete all unused worksheets before I save to my computer. Can you help?

I am looking forward to learning more about macros and VBA. I took Excel in school and use it daily on my job. One of our biggest uses is Excel pulls files from our data base and we use them for different things I would like to lear more on how that works. Thank you for sharing.

We routinely receive spreadsheets that have to be “normalized” before we can import the data into other programs. Typically, that means removing leading “1’s”, odd characters (dashes, parenthesis, etc.). Also, we have to normalize dates/times and often set a custom date/time of dd/mm/yyyy h:mm:ss. And, we look for certain values in a particular column. If a line contains that value, we want to somehow highlight that line for further review. I nearly forgot, for some of our processes, we need to identify and isolate those lines which contains blanks in a certain column or field.

Thank you for video 1 it was really clear and easy to follow. I have used the macro tool to generate macros but often forget to do one task and then have to start all over again to include that task. I can see now how easy it would be to add in a line of code and hopefully after your next videos I may even be able to start from scratch and write the whole thing myself.

Where I have often struggled with macros in the past is when each month brings data with a different number of rows. It would be good to understand how to handle those please.

Thank you for the videos Jon !! I’ve only seen video 1 yet but I like your color coding of the different objects, properties etc.

I work with designing traffic signs on a 4 km long part of a new highway with 8 different scenarios depending on operators choice or accidents. All in all I have around 90 sheets in a workbook, each with a series of signals that introduces new signals down the road in the next time frame. I have up to 12 time frames but most scenarios only use 4-6. I want to learn how I can simulate each scenario to see if they work before I implement them in a PLC at site.

I want to build a graphic over the highway in a separate sheet (plus exits and ramps, bypasses and all signs and text messages to drivers) with bottoms for each scenario (=a macro) showing what will happen over time. – and I want them to work on Office 2016 on both PC’s and Macbook Pro’s.

Giant task to build such a macro system, but small compared to have the overview of “jumping around” from scenario to scenario without ANY fault presented before an imaginary driver.

I know it can be done, I’ve seen it in another company with the same amount of data and complexity, – but I don’t know how to program it myself (yet).

Thanks Jon – I’ve dabbled with the Macro recorder in the past, but recently I’ve been tasked with more Excel work, including working on one or more dashboards for the department here. Video one has given me a base to launch from and look at the ways in which Macros and VBA could help me with the background pivot tables etc. Thank you, and I am looking forward to the next videos.

Tony

I really enjoyed the first video. I have used the recorder, but want to write my own macros. I have worksheets provided to me by other departments that group requirement numbers into one cell for a test case. I prefer to have each requirement covered in a separate cell (row). I would love to learn enough to be able to duplicate the information in the other cells in the row that lists the test case and then only put one of the multitude of requirement numbers currently in the requirement cell in the new row. The macro would need to run in each row the number of times that is equal to the number of requirement numbers in the cell.

Hi Jon – every week I download an excel report from our scheduling system that I then have to cleanse ( remove blank columns,pictures, insert another column and then copy a date to each row in the inserted column), and then repeat this for each day in the report. The end result is then copied into another excel table and then a pivot table based upon the excel table is then refreshed. I am looking to automate this process.

Thanks

I hope you’re well I saw your which was simpler than I found in YouTube.

It gave me a clear understanding about what is the property and method.

Thanks I hope I will find other videos as the same

Regards

Muhammad Yasin