Linking macros to items in a drop down list

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cweicker

Thread Starter
Joined
Jan 29, 2013
Messages
1
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.

HELP!:(
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top