Manual calculation for part of a sheet

[jsmith1234]

To start with, I have no VBA experience and I've tried searching for a solution to applying manual calculation to only part of a sheet, while the rest of the workbook is automatic. I couldn't find anything out there.

My situation is this: I have a workbook with about a dozen sheets. One of the sheets is heavy on formulas which update data from a website. The formulas in each row download data from a website based on the name in columnA and do of math on it. I want the ability to calculate one row (for a few selected columns; other columns need to be on automatic calculate) at a time on command (this command could eg. be trigerred on by a 'on' in columnB and trigerred off by a 'off' in columnB)

If no straight forward solution, I was thinking of using this solution - Create another back up sheet which would be hidden. Make the backup sheet mimic the main sheet (by copy + paste values) everytime a change occurs on the main sheet (which could be new row inserted at the end or in the middle, row deleted, one ore more rows calculated etc. The main sheet would then have the if statement (instead of myformula): if (trigger="on", myformula(), backupsheet!cell) in each column that I want the calculation to be manual. I think this way I can keep the entire sheet on automatic calculate, but still maintain control of calculating only the rows of my choice in the main sheet.

I'm trying to code the above but having a nightmare due to my inexperience. Pls hep. Thanks

 

[JoeMo]

Why not put calc on manual and just have a macro calculate the sheet after each website update?
Is the website update done by a macro now?

 

[jsmith1234]

Why not put calc on manual and just have a macro calculate the sheet after each website update?
Is the website update done by a macro now?

That's exactly what I have now; but it is not ideal. Few of the columns do some calculations with real-time stock data and needs to be computed every 2 mins. The other columns can be static and only updated on command.

 

[JoeMo]

That's exactly what I have now; but it is not ideal. Few of the columns do some calculations with real-time stock data and needs to be computed every 2 mins. The other columns can be static and only updated on command.

If you are willing to use macros, you can arrange to calculate only those columns of interest, but the calc option must be set at Manual. What columns in the sheet do you want to calc on demand?