So it's probably obvious that I am a newbie by looking at my code. Why doesn't this work? What should I do to fix?
In this example I use the Excel Formula in C3 =CountA(Sheet2!A:A), which returns the value of 11 (number of rows not empty), which includes Headers.
I want to copy the Range on...
Here's the scenario:
I have four MS Excel workbooks, each with the same number of columns (A - F) that contain inventory information on Sheet1.
I want to copy each of these four sheets into one master list. Can anybody help with this?