I have created a spreadsheet for wind loads and beam spacing - Lets call it 150 B now I would like to create 150 C I would like to take all the values and reduce them by 5% - can't I create a macro or formular to do this for the whole sheet instead of retyping all values.
Thanks
Enter 0.95 in a cell, copy, select all the cells of interest, paste special, tick multiply and values, then press OK.
Entia non sunt multiplicanda sine necessitate
I am stopped at paste special, I do not have those options
What options do you have in the paste special window?
The cell where you enter the 0.95 should be in the same workbook as the cells that you are going to multiply.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Unicode Text
Text
Ok, user error - but still not working correclty - I've put typed .95 in a cell then copied it then selected several rowsand columns, click paste special, selected values then multiply , then and all values chnage to .95
Those are the options you normally get when you are copying from an outside source into Excel. You cannot do anything between copying the cell and selecting the data range where you want to copy it to. Is that what you are doing? I am attaching an example for you to look at. When you are copying the cell (with 0.95 in it) you will see it with a dotted line around it until you are complete.
Don't select "values" just "multiply"
This is madding. I am doing exactly what you have told me. I don't have a "snap shot" program and I don't have "pc anywhere" product otherwise I would show you step by step, I feel like I am doing it correctly. Frustrated...thank you
Another option is as follows;
in another column, let's say your data is in Col A, beginning in A2
In B2 (for example)
=A2*0.95
and copy that down.
Then copy the entire column B
and Paste Special > Values into Col A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks