Question on Macro functionality

**fatboylard** · 01-30-2012, 04:56 AM

Hi all,

I am looking to send out several Excel spreadsheets to different departments all with the same questions though. When they return I am looking to create a macro that would extract the data i need, perform a calculation and put it into a separate Excel spreadsheet. My question, Is this possible ?

I thought that i may need a DB.

Thanks for any help guys

**arlu1201** · 01-30-2012, 05:27 AM

Its possible.Why dont you attach a sample file and we can help you.

**fatboylard** · 01-31-2012, 02:58 PM

Hi,

sorry for the delay couldn't get on yesterday. Here is an example of a table in the questionnaire, lets just say for example i wanted to take the electricity costs for everyone who returned the form and display that information in another table so that all electricity costs can be seen.

Thanks for any help.

**royUK** · 02-01-2012, 02:31 AM

Am I missing something? There's only a chart in the example

**fatboylard** · 02-01-2012, 09:16 AM

No your not missing anything, just asking how information on this chart could be captured and then placed in another spreadsheet along with several other depts charts. for example if i sent out this chart to 6 different depts and i wanted to display their own electricity usage how could i do that. the real questionnaire has several of these tables produced from the questions, do you need to see the whole document ?

Have included a couple of charts with information for reference.

**arlu1201** · 02-13-2012, 05:14 AM

If you need to display each department's usage then you need to start with the data. You cant directly split out the chart. You can have a format created wherein you select the dropdown and the chart changes to reflect data for that dept. You will need some complex formulae for that, but its possible only with the data.