At times you may wish to open a workbook, add a couple of items from the workbook you are working in to a list and close the workbook. This type of update might be done on a specific set of cells and the results are added to the bottom of a list in a destination workbook.
Let's say we have data in Cells B10:B11 and we want to update our master workbook.
In cell B9 I have a path:
B9 = D:\Example1.xlsxRead More
I was asked during a webinar recently how you send multiple worksheets to a new workbook in a batch. I was pretty sure this information would be on my site but a quick search of my site did not reveal any joy.
I put together a simple file which sends an output sheet and two source data sheets to a directory saves it then starts the process again after changing a unique identifier. The process is a little more in-depth than sending just one sheet but there is not a great deal more code involved.Read More
Convert Formula to Relative or Absolute April 10, 2019
Convert Entire Excel Workbook to Values March 11, 2019
Evaluate with Excel to Extract Sequence March 6, 2019
Extract the First Item from a Horizontal List February 27, 2019
Create Number Sequence with VBA Custom Function January 15, 2019
Protect a Worksheet, Use the Autofilter October 18, 2018
Countifs Across Sheets October 10, 2018
Excel VBA to Select Sheets September 22, 2018
Power BI Desktop Dashboard August 20, 2018
New Excel Dashboard Tools August 1, 2018