Convert formula to VBA code without viewing the formula in Cell

[KumarPK]

Hello All,

I need help here, I have a worksheet which contains project details, I have calculated percentages in excel formula, each time we are entering the Baseline amount i want to copy the formula and paste for next cell.

Now I don't want this i need to automate like once we entered the baseline in cell E:E amount its automatically calculate the Pricing % in cell I:I.

The formula is E:E in baseline and % Pricing in I:I column ( Formula is Actual amount ( Cell G:G / Baseline E:E)

Kindly do the needful.

Regards
Kumarpk

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[JBeaucaire]

Something like this in the sheet module:

Please Login or Register  to view this content.

[bakerman2]

@ Jerry

Isn't it supposed to be?

Please Login or Register  to view this content.

[KumarPK]

Hi Jerry & JB,

Thank u so much for your valuable reply, but its not working on my sheet.

I have attached the sample file for your reference.

Kindly do the needful .

Regards
KumarPK

[bakerman2]

Put next code in the sheetmodule of Sheet1.

Please Login or Register  to view this content.

[KumarPK]

Hi Bekerman,

I just wondering if I put in sheetmodule of Sheet1 still its not working..

I have attached the file, can u please try from your side once...


Please let me know if I did something wrong...?


Regards
KumarPK

[bakerman2]

What isn't working for you? Entering a value in column E gives me calculation in column I same row.

[KumarPK]

Hi Bakerman, Good afternoon,

Sorry for the inconvenience, I have checked again still its not working. Please find attached sample document. Let me know if I did something wrong.

Regards
Kumar Pk

[bakerman2]

Put the code in the sheetmodule of Sheet1, NOT in ThisWorkbook.

[JOHN H. DAVIS]

You placed the code in Thisworkbook - General. Right click on the sheet tab - select View code. That's where the code should have been.