Use personal.xls as lookup sheet?

  • Thread starter Thread starter lk
  • Start date Start date
L

lk

Hi guys,

Can anyone give me any comments against using the personal.xls sheet as a
place to store lookup tables?

I will not be distributing spreadsheets accessing these tables to anyone
else.

The tables will be income tax tables which will be references from other
workbooks on my local hard drives.

Thanks

Frigid Digit
 
Just a personal <bg> opinion...

I wouldn't do it.

It would clutter my workbook. If I had to change the table, it would be too
easy to mess up my real personal.xls file.

Why not just use a dedicated workbook/addin that contains the table?

It just seems a little safer to me.

And when you're done with the project(?), you don't have anything to clean
up--just move it or uncheck it from the Tools|Addins menu.
 
Dave Peterson said:
And when you're done with the project(?), you don't have anything to clean
up--just move it or uncheck it from the Tools|Addins menu.
Click to expand...

When do you ever finish with tax tables Dave? :-)
 
End of the fiscal year???

But if it never is finished, it might even be more important to keep it separate
from personal.xls.

This might be even more important if the OP wants to share that workbook with
others. I wouldn't want to overwrite their personal.xls to give them the table.
 
To quote the OP ...

I will not be distributing spreadsheets accessing these tables to anyone
else.

Bob

(remove nothere from email address if mailing direct)
 
I've started that way, too <vbg>.

Bob said:
To quote the OP ...

I will not be distributing spreadsheets accessing these tables to anyone
else.

Bob

(remove nothere from email address if mailing direct)
Click to expand...
 
Thanks for the responses guys!!

Decided to keep a backup of my original personal.xls with all VBA code
intact before I transfer my tax tables. I figured I could always remove the
sheets if I do ever decide to give the file to someone else.

Have a good weekend.

LK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlooup will not work correctly if lookup table is on another sheet 6
Create employee attendance db using personal.xls? 3
vlookup uses only first 8 characters of the lookup value? 2
Lookups: Three way match? 5
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
Lookups - how to obtain data from a master spreadsheet into another 5
Calling a Personal.XLS Sub from anther workbook's 'This Workbook' Sheet Activate 2
Get Name of Sheet to use in Macro 11

Back
Top