Is that a macro or what?

[Nathalie]

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]

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.

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)

 

[Nathalie]

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]

Nathalie, do you want the data on the same sheet or another?, do you
only want a sum of values for a chosen reference number?, will the sum
always appear in the same place?

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


Office Discussion' (http://www.thecodecage.com))
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)