Define a generic name
Nelson wrote:
I have created a template which will be used to create customer profiles
problem here is I want to use names (example Cells A1:A100 = date) without
associating it to the name of the worksheet.
So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100
Can this be done ?
Try this:
=INDIRECT("A1:A100")
|