Macro To Mark Up A Complete Column By 10%

Dec 18, 2008

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.

View 8 Replies


User Has To Click Button To Mark Task As Complete....

Jan 22, 2009

I have a spreadsheet that users update which I then want them to perform a number of checks on. At the bottom will be a button for them to click stating "Click here to confirm checks completed". When they click it I want it to put a flag somewhere that I can then use to prevent them from saving if they haven't clicked the button. I know how to do the saving but, but how do I get the button to put a flag somewhere?

View 2 Replies View Related

Mark Cell By Column And Row Value

Feb 2, 2014

I have the following formula and need to incorporate that it is only a "B" if B20 also matches in named range "Breakdown_RSC"

Formula: ...........

I need the following section to take into account the data in B20 as in if it matches the data in the cell it should be a "B" in the cell.

View 2 Replies View Related

Mark Cells Where 2 Column Conditions Are Met

Sep 4, 2007

I have a macro that's supposed to update the value in column 1 when two conditions are met. Unfortunately it doesn't update the column at all:


Dim item, rownum, maxrownum As Integer

Application. ScreenUpdating = False
maxrownum = Range("A2000").End(xlUp).Row

For rownum = 2 To maxrownum

If (Cells(rownum, 1).Value = "=") & (Cells(rownum, 29).Value = "OPEN") Then
With Cells(rownum, 1)
End With
End If

Next rownum

End Sub

I took the code from another spreadsheet I have where it works fine. But there only one condition has to be met before the field is updated.

View 4 Replies View Related

Autofit, But Not The Complete Column

Feb 2, 2009

I have some Worksheets in which cell A1 contains a textual heading for each Worksheet.
On each Worksheet, cells in the range A2 to O5 containg headings; the data goes in rows 6 onwards.

In VBA script, I'd like to autofit columns A to O, but starting at row 2 so the text in A1 is not included. For each sheet, I can determine the last row, to get a "range" to autofit (e.g. "A2:P15").

I've run a search on Autofit; the only examples I can find autofit the whole column or set of columns.

Is it possible to autofit starting at a specific row?

View 9 Replies View Related

Mark Multiple Entries In The Same Column With Numbers

Dec 11, 2007

I have many wordlists, which have multiple entries in one column. I would like to mark up entires which appear more then once with numbers 1,2,3....The number should be put at the end of the word or ath the beginning.

Before Macro:

Column A


After running the macro:

Column A

Love 1
Love 2
Lonely 1
Lonely 2
Living 1
Living 2

View 10 Replies View Related

Mark Duplicates That Are Identified In A Seperate Column

May 7, 2007

I am looking for a way to ease a 24,000 line duplicate list into showing just the files from a specific folder/subfolder and its dupes. I have marked the files that reside in that folder by adding a column and entering a "1" in it. What I am looking for is a way to add that "1" to the others of that unique numerical ID duplicates, so I can sort and trim the list to just those files. End result is to show files in one folder and the locations of duplicates of those files elsewhere for eventual cleanup.

Very loosely, if C2=C1 and B1=1, then make B2=1 (and so on)
(A is blank and only there in case a formula needs input there)


View 9 Replies View Related

Conditional Format To Mark Increase From Previous Column

Sep 5, 2013

I have a goal set for the year. With conditional formatting, each month will be set to either red or yellow based on where it stands in relation to the goal. I would also like to show an increase or decrease in productivity for each month. I tried to use conditional formatting with the formula:

=IF(C2=D2, "", IF(C2<D2,"↗","↘")).

The formula works on its own without the conditional formatting so I am not sure what I am doing wrong. I've attached a sample with all the conditional formatting and formulas in place.

View 5 Replies View Related

Add Auto Complete Macro?

Mar 19, 2014

Is there a way to add auto complete to this Macro so that when a user starts typing in a cell in column A it auto completes.


View 2 Replies View Related

Loop A Macro Until Complete

Aug 1, 2007

This macro seeks out "Time Zone" and highlights a block of rows around it and deletes them.

How do I loop it until all instances of "Time Zone" are gone? ...

View 7 Replies View Related

Change One Variable When Dragging Down A Column To Auto-complete?

Feb 25, 2013

How do you drag down a column to auto complete the values but do it so it only changes one variable.For example, I am dragging down =IF(ROW()<=$B$5,MOD(E2*B1,B2),"") down my column.

However, I only want the "E2" value to change, and I want B1 and B2 to stay that way. Whenever I drag down, it keeps changing all three values. Is there a way to make it just so that the E2 value is the only one that changes?

View 4 Replies View Related

Make Macro Wait For Process To Complete

Feb 4, 2010

I'm using a pre-made spreadsheet from my stock broker (Interactive Brokers) that retrieves and displays real-time quotes, and allows one to retrieve historical stock data, among other things. I've created a little macro within it to try and automate some common tasks I do everyday - basically I want to retrieve a year of daily stock quotes for "stock 1" from IB's servers, then have the macro wait for the retrieval to be done and written to the spreadsheet (takes anywhere between 10 and 30 secs). After that's all done, then I want to do the same for "stock 2". Then when that's done, the macro proceeds to go ahead and do some calcs on stock1 and stock2. The problem is after my stock1 data request, the macro just keep on trucking through to the next commands while stock1's data retrival is still going on.

so things are getting all balled up. How can I get my macro to wait until stock1's data retrieval is all done?

View 14 Replies View Related

Macro For Searching Exact/Complete Word

May 8, 2008

I already have this code written but it looks for all words that contain my desired word. i.e selecting "innovation" while looking for "ovation"....

View 9 Replies View Related

Simplified Macro That Copies Col A And B From 12 Sheets To Complete Sheet

May 13, 2014

I have this code that works where Column A and B from 12 sheets are copied to a "Complete" sheet where it is saved as a CSV file for import.

I'm fairly new at this and know this code could be simplified to loop through the 12 sheets instead of copying the code 12x!!

I've copied the code for the 1st 2 sheets:

For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
OutSH.Cells(1, outcol).Value = Cells(i, 1).Value
OutSH.Cells(2, outcol).Value = Cells(i, 2).Value
OutSH.Cells(2, outcol + 1).Value = Cells(i, 3).Value
outcol = outcol + 1

[Code] ......

View 1 Replies View Related

Macro Does Not Complete: CHECK For Sheets THEN Copy DATA

Jan 26, 2009

I have a macro that will not complete, and I can not figure out why. The macro is CHECK_for_Sheets_THEN_Copy_DATA:

View 3 Replies View Related

Excel 2007 :: OFFSET Formula With Defined Name Not Selecting Complete Column

Jun 2, 2014

I've created a search box for a price list, but some of the values come up with #REF. After many attempts I noticed that each of the formulas I created on the price list page came up with a different result for the values highlighted in each column. The formula is the same for each column, the column numbers being the

only difference - for instance:
Column A = code - the formula is =OFFSET(Pricelist!$A$3,0,0,COUNTA(Pricelist!$A:$A)-1).
Column D = colour - the formula is the same, but reads $D$3 and $D:$D.

When I go to Name Manager and check this formula, it only selects the first 105 entries in the column. There are about 380 entries and more may be added at various stages.

I have formulas for five other columns and they do exactly the same thing, but each column stops at a different entry. I'm working in Excel 2007, but it's a 2003 document.

View 1 Replies View Related

Macro To Separate File Name And Path From Complete Path

Oct 3, 2012

I want to run a macro to separate File Name and Path from the given complete path

For Example


In Column A : Given Complete Path " C:MainFolderRecordsSubFilesFile1Record.pdf

I need it separeted like


In Column B :File Name = Record.pdf
In Column C :File Path = C:MainFolderRecordsSubFilesFile1

Is there any way to do this through a macro

View 2 Replies View Related

Mark Up Formula

Oct 1, 2007

i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price

to work out the retail price i need to sue this forumula

retail price = wholesaleprice + x% of wholesale price

im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!)

View 10 Replies View Related

How Do Mark All Posts?

Feb 26, 2009

how and where to navigate on the website to mark all my posts solved. Sometimes I don't see the edit button, I don't know how to list all my posts, etc.

View 5 Replies View Related

Look Into Another Workbook And If Value Is There - Mark As Yes

Jul 22, 2014

I have two workbooks, lets say book1 and book2

In column A of book 1 i have a list of numbers, going down to A250

A1 = 23423423
A2 = 23442345

etc etc

I would like some code for a button press, if the value in A1:A250 is in book2 (A1:A250)

Both workbooks will be open at the point of the button press

then adjacent cell in B1:B250 is marked as Yes

View 5 Replies View Related

Character Mark In A Box

May 23, 2008

I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this

I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.

When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!

I'm using Excel 2007.

View 9 Replies View Related

Find And Mark

Mar 16, 2009

I have to manually enter the code nos. of the hard copy to find the code in the soft copy. After finding the number, I wish to mark it as so that double work should not be done or to find which code's hard copy is not with me.

I am using Find and Replace to find the number and after it is found I have to click the replace tab to enter colour in it.

Is there any auto function to mark as soon as I find the required number instead of clicking the replace tab to save my time.

View 9 Replies View Related

Mark Intersection Of Two Items?

Mar 3, 2014

I am making a rough gantt chart in excel for a project schedule. Japanese at work love excel fro some reason that is why I am trying to do this. I have column headings for days ( 3/3, 3/4, 3/5, etc) and I want to find a way to mark the intersection when a date is input in another row. I tried to do some conditional formatting using symbols, but couldn't get anything to work.

see picture. I want to mark at correct date according to column headings when date is placed in column E or F. This example shows column E with 3/10 so I want to make a value appear at intersection AS and the row 3/10 is on. Would like to get a symbol to appear there if possible.

excel help.png

View 5 Replies View Related

Click And Mark A Cell With An X

Dec 18, 2008

Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?

View 11 Replies View Related

Mark A Thread Closed?

Feb 13, 2009

how do i mark a thread closed? I looked in tools and lots of other places?

View 4 Replies View Related

Mark Dates With Colors

Nov 22, 2009

i want to know how to mark the cells with color where the starting date is not greater than ending date.

View 4 Replies View Related

Mark Repeating Field

Dec 27, 2008

I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated.

So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. How would I go about separating the duplicates (to then delete them)?

It's sorted by address then consumption. The logic is...

if the address value in column A repeats and the consumption field in column B also repeats, then...(place a marker in column C so I can sort and delete)

View 2 Replies View Related

Cost Based Mark Up

Sep 26, 2007

set up a cost based markup spreadsheet?

I need to be able to mark up values from 0.01-9.99 by 20% of their value, and 10.00 and above by 10% of their value.

I only know how to mark up values by a single percentage.

View 9 Replies View Related

Find And Mark Duplicates

Dec 16, 2008

I need to find duplicates subnet information in row F and mark the words "Duplicate"
Then I need to do the same with Row K. I need to find any duplicate subnet masks.

The reason for this is that I merged two orginizations into one spreadsheet and I need to find the duplicates in Company A and Company B's subnet and mask information.

View 9 Replies View Related

Mark Formula Cells

Aug 14, 2009

I have a problem - I wanna to mark (to colour) just cells which I use in formula is there any option for thise

If I have some table and I have formula =A1+B5+C7 I wana to colour just mentioned cells

View 9 Replies View Related

Copyrights 2005-15, All rights reserved