Posted on February 26th, 2009 by Joseph Harris
Q:
Joe,
I have data in another workbook that I want to pull into my current workbook. How do I do this?
Unsigned
A:
The easiest way to accomplish this is to open both workbooks. In the workbook you want to pull the data to, enter =, then go to the workbook you are pulling from and select the cell [...]
Posted on February 16th, 2009 by Joseph Harris
Reader Writes:
Joseph,
I have a spreadsheet set up where I enter all of my companies “packages shipped” data. I would like to know the value of the last row that I inputted. So, if column A contains packages shipped on each row, I want to know the last number entered in column A.
Thanks,
Carl
…………………………………………
Carl,
You can find the last [...]
Posted on December 4th, 2008 by Joseph Harris
Q: I need to count the number of times an item occurs in column a if another thing also occurs in column b on the same row. I don’t think countif can be used for this can it?
A: You are correct in that countif cannot be used for two arguments in that manner. The simplest [...]
Posted on November 12th, 2008 by Joseph Harris
Q:
How do I remove all the macros from my workbook? I don’t want the “this workbook contains macros prompt” to appear anymore?
Thanks,
Rodge
A:
Rodge,
There are three things you can do to get rid of the macros message when you open the workbook.
Set the macro security setting to low.
Move all of your worksheets to another workbook.
Manually delete the [...]
Posted on November 6th, 2008 by Joseph Harris
Correlation coefficient use
Posted on October 29th, 2008 by Joseph Harris
Q:
Hi,
Can you tell me how to show the worksheet name in a cell in my workbook?
Thanks,
Ted
A:
Ted,
You can do this with the built in functions in Excel. The CELL function with the filename argument, =cell(”filename”), will return the entire path of your workbook along with your current worksheet. We can then extract the worksheet name by [...]
