+ Reply to Thread
Results 1 to 17 of 17

Macro to to table lookups/operations on values entered by user

  1. #1
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Macro to to table lookups/operations on values entered by user

    i'm italian, i'll post an attached in italian..maybe someone can help me

    Thank you
    Attached Files Attached Files
    Last edited by 6StringJazzer; 03-14-2018 at 11:49 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Need a macro to do what i need

    Ciao. Benvenuto al Forum!

    Although your post is in English, you actual question in the attached file is in Italian so I am moving it to the Non-English forum. However, I will try to help myself because I speak some Italian, the data is simple, and maybe I can help.

    I am also going to update your title once I figure out your question, because it's your first post. Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. Every thread here is from people who need a macro do to what they need.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Posso aiutarla, ma ho una domanda: Vuoi che il client inserisca i valori in A1/2/3, quindi vuoi i risultati in quelle stesse celle?

    (Questo avrebbe bisogno di un bottone per eseguire la macro.)

  4. #4
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    Esattamente ho bisogno che i risultati escano nella stessa cella, non la si può eseguire in automatico?

    In ogni caso grazie mille per la pazienza!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Si non c'é un bottone, qualcosa deva commenciare l'esecuzione. Si non c'é un bottone, forse dopo il client inserisca tutto tre valori?

    Questo é difficile per me in italiano....i tre valori sono indipendenti? Si il client cambia uno, non influenza gli altri due? Si vero, ogni valori può essere calcolato si il client cambia il valori. (Spero io sono chiaro!!)

  6. #6
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    i'll try to explain you in english,

    The customer have to insert in A1/A2/A3 cells a value,i forgot to say i want another cell for example A5 in wich cell have to make a comparrison between A1/2/3 and choose the biggest number, and tht will be the final result!

    the customer have to insert at least 2 of 3 value so he can insert in A1 and A2 or A1 and A3....or all the 3 cells.

    All the value are independent the customer have to put a number where he want, at the end i have to choose the biggest price to make him pay,

    Hope you to understand better the situation even my english is bad,

    Thank you

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    That is very helpful.....

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Tutti le tre istruzioi fanno riferimento alla tabella "MT" ma ci sono anche le tabelle M3 eg KG. Sono le istruzioni dovrebbero dire MT per A1, M3 per A2, e KG per A3?

  9. #9
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    Hi,

    No m3 and kg are only for me,

    A1/A2/A3 all have to take the values from mt,

    So if in A1 the user enter 2.3, in A1 want to do 2.3*180.. but if the values entered is 4.6 A1= 4.6*160

    and for A2/A3 i explain it in the attach and all have to take the number from mt,

    Thank you again for you're time

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Grazie, chiarissimo.

    Penso che finirò presto.

  11. #11
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    Grazie mille a te!

  12. #12
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Devo viaggare oggi e non no finito ancora. Ecco dove sono proprio addesso. Penso finirò piu tardi oggi.

    Mi dispiace che sono lento!
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    prendi il tuo tempo, l'importante è arrivare ad una soluzione

    Grazie mille per quello che fai

  14. #14
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    Don't forget to put a A4 cells that have to choose the biggest value between A1/A2/A3

    Thank a lot

  15. #15
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    Please test this to see if it's correct.

    I added a cell with the maximum, and also the maximum value will be yellow.
    Attached Files Attached Files

  16. #16
    Registered User
    Join Date
    03-14-2018
    Location
    pordenone
    MS-Off Ver
    2016
    Posts
    8

    Re: Macro to to table lookups/operations on values entered by user

    it works perfect, i just need to take out the decimal and round to the biggest number..so 6.222222 will be 6.3

    This for all the cells mt/m3/kg/max

    If in the future i'll need something else can i disturb you?

  17. #17
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to to table lookups/operations on values entered by user

    If you need something in the future, start a new thread but please also PM me to tell me about your thread. But we prefer that you post your question publicly.

    Ciao,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to add another Macro to a button to add into a larger Macro.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2016, 10:51 AM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1