Excel Worksheet/Workbook best practices 1

[Kallen]

It's that time of the year again. Time to re-design my worksheet/workbooks because of the nightmare I created the year before. You see, I designed some workbooks with links to other workbooks. These workbooks would capture certain month end info (for month end reporting). I would capture this info by cost center. I structured it so that the months of the year were in columns and the cost centers were in rows.

Now here comes the problem. If we needed to add another cost center, my links to my other worksheets got all messed up. For instance, I would enter month end info for cost center 1111 and the info for cost center 1111 would wind up on my linked workbook in cost center 2222.

This has caused nothing but problems for me. All of the hard work that I put into this during last year has been poinless as I have to manually enter everything.

To make a long story short, is there anyway I can prevent this from happening in the future? I am going to start from scratch and need advise before I start over again?

Thanks and Happy Thanksgiving!

 

[Dreamboat]

Kallen: Access users don't have to KNOW Access. For real.

Also, you can do all YOUR stuff in Access and let everyone else do theirs in Excel. Just link their Excel workbooks as tables in your Access database. New cost center? New linked Excel workbook as a table.

Anyway...check out the MyVlookup free download at:

http://www.theofficeexperts.com/downloads.htm#ExcelDownloads

Anne Troy

http://www.TheOfficeExperts.com

 

[Kallen]

Thanks for the link! This looks great, I have all of my Excel manuals I use whenever I am trying to use VLookup and it still remains pretty foreign to me.

And yes, I am still considering doing all of my stuff in Access and than using Excel for the end users. I just thought it would be easier doing it all in Excel, but the more I think of it the more I am second guessing. Basically all of my data is coming from Access anyhow. I have these huge tables. I perform cross-tab queries to get them at the sum level and I was going to have to copy and paste that info into Excel anyhow.

Thank goodness I still have another 5 weeks or so to contemplate what to do. )

 

[Dreamboat]

Great. Let us know if you have any problems implementing after you make your decision. Anne Troy

http://www.TheOfficeExperts.com