Hello Simon and thank you for your response.

I have sorted data in excel sheets. What should I do? My reference value is
store number. Is it possible to add up all the data that contains the same
reference value, and that this reference value displays from a list?

Thank you very much!

Nathalie

"Simon Lloyd" wrote:


Nathalie, first things first, you need to create your worksheets with
your data, then when you have your layout and have particular areas or
ranges to deal with we can of course help you with that. Otherwise we
say you don't need a macro, you can simply use Data Validation dropdowns
and VLookup to get your results, but untile you have data and structure
we can recommend neither.

Nathalie;388978 Wrote:
Hello everyone.

I work as a sales rep at a consumption products company. I need to
develop a
tool in excel in which you select a value from a list (store number)
and then
several data displays, such as: monthly sales, percentage of increase,
top
products, etc. I've seen two of these tools done by others, but no one
will
tell me how to do it (yeah, job competition nowadays is harsh). I
looked into
the listo of macros in the sheet and it lists none. Any ideas of where
to
start?

Any help would be really appreciated.

Hugs~
Nathalie
24
Mexico


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=108758