1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Linking macros to items in a drop down list

Discussion in 'All Other Software' started by cweicker, Jan 29, 2013.

Thread Status:
Not open for further replies.
  1. cweicker

    cweicker Thread Starter

    Jan 29, 2013
    Hi all,

    I have a quote file, in Excel, with a drop down list (created through Data Validation) with the names of different companies. For each company, I need to charge different amounts of tax. I tried to set up macros first before I did anything but they didnt seem to work.

    Here is a better understanding:

    For Company A - we dont charge tax
    Company B - we dont charge tax
    Company C - We charge 5% Fee and 5% Overhead (Five rows need to be added to show this)
    Company D - We dont charge tax
    Company E - We charge only 5% GST (1 row will need to be added)

    I have a general format for the companies that we do not charge tax but when I go to set up my macros to change the format for the other companies they do not work.

    PLEASE can someone help me set up the macros for each company and then link them to that company when they are chosen from the drop down list....?

    PLEASE HELP ME!!! I am pretty familiar with Excel and Macros but now that they are not working I do not know what to do...? VBA code is not my favourite.

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1087393

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice