Does it make a difference in size of the workbook to put data all on same sheet?
It would be easier for me to organize on separate worksheets but I am try to keep the size down as much as possible to emailing sake.
Does it make a difference in size of the workbook to put data all on same sheet?
It would be easier for me to organize on separate worksheets but I am try to keep the size down as much as possible to emailing sake.
Size doesn't matter. You shouldn't focus just on simplicity of "use", but also on efficiency of data management.
You say it's "easier' to have separate sheets for parts of your data, and that may be true, until later when you try to start making reports of data that is found scattered all over your workbook in separate sheets.
Whenever possible, use a single sheet for "database", then you crunch that data very easily to create any reporting you need based off of all the data.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks