Link to home
Start Free TrialLog in
Avatar of tawathav
tawathav

asked on

Multiple Excel Spreadsheets Help

Hello-

I have multiple Excel spreadsheets that all have similar data but not exactly the same. I am looking for a way to have the least amount of manual data entry.

All the Excel spreadsheets are filled out manually monthly by several leaders and takes a considerable amount of time. Most of the time the data is than used to create PowerPoints. Also, some of the spreadsheets track new initiatives and results so its not just numbers are all the time.

I am looking for a way to simplify these tasks. Any suggestions?
Avatar of [ fanpages ]
[ fanpages ]

Hi,

How similar is the recurring data?  Can some of it be derived or pre-calculated from previously entered data, from the first workbook/worksheet created, or based on the duties/position of the person entering the data?

Can the PowerPoint presentation file(s) creation be automated?  Can the Leaders perform this task, or is the data collated centrally & another person does this?

It is difficult to advise without knowing specific details of your operation.

BFN,

fp.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Mellor
Anthony Mellor
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tawathav

ASKER

Thanks
pleasant surprise, thanks you.
Yes, a month & a half later I had all but given up on a response to my query.