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

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

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

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?

Nathalie;390412 Wrote:
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' ('The Code Cage - Microsoft Office Help - Microsoft
Office Discussion' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Is that a macro or what? - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=108758)




--
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