If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is that a macro or what?
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 |
#2
|
|||
|
|||
Is that a macro or what?
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 |
#3
|
|||
|
|||
Is that a macro or what?
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 |
#4
|
|||
|
|||
Is that a macro or what?
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 |
Thread Tools | |
Display Modes | |
|
|