I have a workbook that includes several worksheets that are each named with a unique identifier.
One of the sheets is my summary page that references values form each of the sheets. Because it is a pain to write out the name of the sheet each time I copy a formula I would like to grap the name of the worksheet from a value.
for example something like this is in cell B3
so if B2 on my current sheet is 'cjs123' then the formula should go to the sheet called cjs123 and retrieve the value in cell B3.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm),
I will briefly cover:
1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …