Name columns
This was really helpful. Now, if i were to export this to Access, I would
have my columns defined so that i can tell the columns apart, correct?
angie
"Mark" wrote:
On Feb 10, 11:12 am, az-willie wrote:
How do I name columns so instead of column A I have Date?
Select the following:
Insert---Name---Define
Enter the name "Date" in the top text box
Click inside the textbox at the bottom under the words:"Refers To"
Now select column A by clicking on it. There should be something like
the following in the textbox now --- =Expenses!$A:$A
Your sheet name will be different of course.
Hope that got it for ya
Mark
|