unmanageable sheets

M

ManvinderKaur

Board Regular
Joined
Jun 16, 2010
Messages
149
Hi I have one challenge at my new job...
there are 65 partners of a company corresponding to each company there are 65 spreadsheets ..in each spreadsheet there are 3 different templates. each sheet contains data and columns have calculations. each sheets contains same sort of data and calculations . there are 3 summary sheets that contain data from 65 sheets. Now the thing is they are growing and there client may go beyond hundreds.. SO what is soluntion for this. because workbook is not going to be manageable in future. What should be solution. Is that good to make access database?...or any other solution...
Thanks
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Consider restructuring your incoming data (all in Excel) so you can use the powerful features of a PIVOT TABLE for presentation
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Organization Chart Formula
Replies
3
Views
168
ShogunStealth
S
J
  • Question
Complex Move data from two spreadsheets with similar data in different columns to a specific column in an existing spreadsheet(Sheet 3)
Replies
0
Views
165
JMC57
J
J
  • Locked
  • Question
Still need help on a daily summary sheet
Replies
1
Views
353
Fluff
Fluff
C
  • Question
Use Row Data to Create New Sheet from Template and Reference Data
Replies
0
Views
430
ChrisMas92
C
Morpheus2022
  • Question
Training Needs Analysis Formula - Awesome (If I can crack this problem)
Replies
2
Views
435
awoohaw
awoohaw

Forum statistics

Threads
1,216,122
Messages
6,128,964
Members
449,480
Latest member
yesitisasport

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top