# Spreadsheet Help - Anyone out there who can help !!! Please !

Hi Guys

Any spreadsheet Guru's out there? I need to take a value from a cell add 40% then I need to have the next cell display the result. That's the easy part. The hardest part is I need to delete the original cell so only the final value is shown;

eg. Cell a1 value =10

Cell b2 =SUM(I3*1.4) - ( this displays 14 )

I then need to delete the original cell a1 and replace it with the cell b2 result. This is because I have a price from a shop but want to mark it up by 40% and send out the spreadsheet to potential customers without seeing my buy price in cell a1.

There are approx 600 parts so I do not want to type in the result in each time from b2 into a1 each time and I cannot copy and paste the result from b2 as this copy the actual formula and not the figure. Hope this makes sense !!

Rep left for any help

Any spreadsheet Guru's out there? I need to take a value from a cell add 40% then I need to have the next cell display the result. That's the easy part. The hardest part is I need to delete the original cell so only the final value is shown;

eg. Cell a1 value =10

Cell b2 =SUM(I3*1.4) - ( this displays 14 )

I then need to delete the original cell a1 and replace it with the cell b2 result. This is because I have a price from a shop but want to mark it up by 40% and send out the spreadsheet to potential customers without seeing my buy price in cell a1.

There are approx 600 parts so I do not want to type in the result in each time from b2 into a1 each time and I cannot copy and paste the result from b2 as this copy the actual formula and not the figure. Hope this makes sense !!

Rep left for any help

Or did i read it wrong?

Ps - never ever hide things if it's going out to a customer, there are far too many tools around to discover 'hidden' things on spreadsheets and protection removers (I have most of these )

Original Poster

If I dont get any further then I will certainly look at your suggestion as they would work - thanks

Original Poster

Thanks - did try that but it just copied the formula's not the cell value

yeah do that - paste special and click on value this will copy the value rather than the formula. I was only suggesting hiding the column if it was going to go to a pdf btw.

Paste Special,ValuesTry it on one cell -

Ctrl + C

Then go to Edit > Paste Special and select Values - if you just press OK it will copy all parts of the cell including the formula. If you have no luck you can email me the spreadsheet and I'll do it in a matter of seconds for you (assuming it's not too confidential!) :thumbsup:

Values starting in cell A1 for instance & going down column A (A2, A3, A4, etc).

First formula in cell B1 (referencing cell A1), then incrementing down column B.

Once you have the upshifted amounts in column B, select the entire column, copy to your clipboard, then with the column still selected, use the "Edit" / "Paste Special" menu item.

Select the "Paste" / "Values" option & confirm with [OK].

All the formulae in column B will now be values not based on the corresponding cells in column A.

Select column A.

Delete column A entirely.

Job done.

BFN,

fp.

[Experts-Exchange "Expert" in Microsoft Excel :)]

(And someone who typed out all the steps & missed everybody else providing the same answer several comments back!)

Original Poster

Absolutely spot on. Thanks you have saved me hours of manual inputs. It worked a treat, I use open office so the options were slightly different.

Thanks again rep left

Original Poster

rep left

Always best to mention this in your question!

Glad you resolved your issue in any respect.

BFN,

fp.