Fuction Exel VBA

Job ID: 32619539

Budget: $30 – $250 USD

Sheet ark 1 B3 to b200

make a function if you puch cell B3 to B200 then goto Sheet same name as the number inn cell B3 to B200

Exemple: you push on field B3 then goto sheet name” 1099” because
Sheet ark1 cell B3 value is 1099

If sheet name “1099” not exit then make a function create new sheet
The new sheet must be a copy off the Sheet “Original”
After create the new sheet rename the new Sheets to the name as field B3
When you have rename the new sheet you must make change inn the new sheet inn field B2
Here you must insert sheet name (1099) inn field b2

Last change you must change cell e28 and get the value from ark 1 B3 to e28

Importen: The time I use the sheet value inn B3 can be 1100 and not 1099

I am not inn the office the next 3 days if I not reply

When this task is done and if I am satisfied I should have made more exel vba
Related categories: Excel VBA Excel Macros