Hi all,

I have a document where you can enter up to ten part numbers and it will connect to SAP and input your data for you.

For each quantity of parts you enter (e.g. 1, 2, 3, 4 up to 10) there is a different macro that must be run.

Is it possible to create a macro that will call a certain macro depandant on how many cells have been populated.

E.g. i have a count if column which indicates how many parts have been entered, dependant on this count i want it to call a certain macro.

Sorry for my ignorance in this matter!

Many thanks,
Matt