vba code for excel formula

[devawad]

Hi all,

I want vba code for my excel formulas, I attached my original sheet and I want vba code for all the formulas in it.
In my attachment yellow coloured columns contains the formulas based on its left column cell value.


Thanks in advance

Dev

[kvsrinivasamurthy]

Try this macro

Please Login or Register  to view this content.

[devawad]

Dear kvsrinivasamurthy ,

Thanks for the code, but I don't want to put any (macro) button on the sheet,Want the code which will work exactly the formula does.without putting any formulas in excel sheet.

Thanks in advance
Dev

[kvsrinivasamurthy]

Try this code

Please Login or Register  to view this content.

[jaslake]

Hi Dev

Is your Pune Sheet complete or might there be additional items?

[devawad]

Dear jaslake,

Yes there will be addition in Pune Sheet.

Dev.

[jaslake]

Hi Dev

Will there be new Formulas with these new additions? Can you supply a Table of all possible Formulas?

[devawad]

Hi jaslake ,

I have added all the possible new additions and formulas in new attachment (dev sample1).

Thanks in advance

Dev

[jaslake]

Hi Dev

The attached File has an "Initial Set Up" routine that creates a Sheet called "Lists". This Sheet contains a Table of all the Formulas as extracted from Sheet Pune. It also CLEARS ALL DATA AND FORMULAS from Sheet Pune, Columns C to the last Column to the Right.

This Code must be run ONLY ONCE as it destroys all Formulas in Sheet Pune. The Code is in Module 2 and can be executed with CTRL + x

Please Login or Register  to view this content.

In Sheet Pune all of the Data Entry Cells have been unlocked (Columns C, E, G, etc to the Right). This Code is in the Workbook Open Event and Protects Sheet Pune but allows Macros to Update the Sheet

Please Login or Register  to view this content.

This is the Code that does the Dirty work...it's in the Sheet Module of Pune

Please Login or Register  to view this content.

You can add as many Columns to the Right as you wish. You CANNOT add rows (you can but it requires special instructions). Let me know of issues.

[devawad]

Dear Sir,

Thank you so much...


Dev.

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.