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
Recently I was assisting someone on a forum and the workbook they had supplied had been saved as a shared workbook. I have not used shared workbooks and was at a bit of a loss regarding how I might un share the document. I needed to un share it in order to make changes to the structure of the workbook – add lines/columns. These are the steps to share or un share a workbook.Read More
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019
Excel Dashboard by City May 16, 2019
Excel Timesheet Example May 9, 2019
When TRIM Doesn't Work in Excel May 8, 2019
Excel Now Has 3D Pictures May 1, 2019
Using Index as a Dynamic Range April 30, 2019