i have a excel file i need to markup by a 10% value. It is the L column starting at row 2 till a varying number of rows. i need to mark up all of the rows in the spreadsheet. i do not know how to make it repeat.
This is the formula =L2*1.1(i think its the right one) but i do not understand how to make it repeat. any help would be greatly appreciated.
I need the value to be replaced with the marked up value. TIA
Last edited by focodelic; 12-26-2008 at 10:10 PM. Reason: solved
Assuming you put that in M2 (next to L2), just select that cell, hover your mouse over the little square in the lower right corner of the selection box (called the 'fill handle'), left click, and drag it down.
Entia non sunt multiplicanda sine necessitate
thanks for the quick reply, I have been doing alot more reading on this. I do not think this is going to be an easy task. i have a spreadsheet that is exported every 45 minutes. I need to mark up an entire column( it varies in number of rows) by 10%. I need the value to be replace with the marked up value. I am not even sure this can be done but i need to keep it in the same column.
Here's dirty little macro to up L2:L1000 by 10%. See if this does what you want. Just click the button.
Last edited by JBeaucaire; 12-19-2008 at 03:58 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Or you could try something like :
Please Login or Register to view this content.
Thanks that seems to work. I just need to know how to make it save after it adds the 10%. Thanks
If you just need to save :
if you need to save it as something else try(change my path to where you want it saved):Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks everybody for all of your help.
If you're a happy camper, would you please mark this thread as Solved?
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks