Numeric data to dialogue

[KevyWevz]

Greetings, Excel gurus!

I am not 100% certain which sub-forum this question would belong to so am just putting in 'General' until a mod/admin decides it't rightful place

I have a weekly report that I present to senior management taking several numbers from various Excel sheets but it is currently becoming a bit more tedious than it should be for what it is delivering. Ideally I would like to input the data to my Excel sheets and have the dialogue update itself. So it would ideally look like

"In Week01, our ability to hit target was surplus/deficit by +/- 10%..." etc

There would be several lines of such dialogue referring to various KPI's and I would need the numbers in the cells to determine if the words positive/negative are used or even if the 'plus'/'minus' symbols are used.

From my own research I believe that I will need to create a macro using some basic VBA code to create the desired dialogue from the data in the cells but the tutorials I have found so far have not been specific to what I am asking. I am sure I have seen this done before but unfortunately do not have access to the file where I saw this nor the person that created it!

Any help would be greatly appreciated here(pointers to tutorials that I could use to learn how to create, or if anyone feels like holding my hand that would be great too )

My thanks!
Kevin

[oeldere]

Please Login or Register  to view this content.

you have 1 workbook with differant sheets

or

you have several workbooks?

[KevyWevz]

Please Login or Register  to view this content.

you have 1 workbook with differant sheets

or

you have several workbooks?

I'll be putting all relevant data to one workbook with different sheets.

[oeldere]

If the lay out of all sheets are the same I would solve this adding all data on one (master)sheet.

After that you can analyse the data with a pivot table.

Adding the data on 1 (master)sheet can be done with copy / paste or VBA.

[KevyWevz]

All sheets have identical layout and all info could indeed be move to a master-sheet but I am not sure it is wise as each sheet requires it's own 'report' and thus it's own dialogue

[oeldere]

Ever worked with pivot table?

Please Login or Register  to view this content.

Maybe you can post and small excel file without confidential information.

Please also add the requirement of the report (in the file).

After that I will take a look at it and come back with you.

[KevyWevz]

Done, thanks oledere! I have attached a file with some 'inputs' and 'outputs' and some text as an example of how I would like to display the data. Hopefully that helps!

I work with PivotTables often but I really only work with the very basics of pivot tables. I normally use it to arrange some numbers into an easy to read format when working with large quantities of data but nothing more complicated than that.

[oeldere]

Please Login or Register  to view this content.

Where do I find the inputs (tabs)?

[KevyWevz]

Apologies for the delay oeldere

In the file I attached the 'Inputs' and 'Outputs' are all on the same tab, I thought it might be simpler to have everything visible on the same tabs. The reports we work with are similar to that format and I must write a narrative of the numbers so I would like to set up the file to write as much of it as it can

[oeldere]

That don't answer the question in #8.

Where do I find the input. (which range)

Where do I find the output (a1:b9)