Start Free Trial

asked on 5/16/2013

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?

Microsoft Excel Microsoft SharePoint Microsoft Access

Last Comment

7/2/2013

5/16/2013

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

5/16/2013

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

7/2/2013

ASKER

Thanks

7/2/2013

pleasant surprise, thanks you.

7/2/2013

Yes, a month & a half later I had all but given up on a response to my query.

Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY