Automatically Fill Cell Value Based On Another Cell

Dec 2, 2008

I have certain values in cell B4 to B2000. There are 25 unique values in those cells. In cells A4 to A2000 I would like to put a identifier (lets say a letter from A to Y) based on the adjacent B4 to B2000 cell values. I can't use a IF function because I am way over 7 allowed in excel. I could use a vlookup but that seems to slow down the file quite a bit. Is there something else better/faster out there?

ADVERTISEMENT

Automatically Fill Cell Down X Rows Based On 2 Other Cells

Feb 26, 2008

Suppose in cell A1 I type in the number "100" and in A2 I type in the number "5"
What I want to do: Have the number "100" repeat 5 times in a vertical list (so 100 appears in B1, B2, B3, B4, B5)

View 2 Replies View Related

Get The Price To Automatically Fill Cell?

Mar 27, 2014

I am trying to get the Price to automatically fill cell C11 of the attached spreadsheet when a user enters Grade and Thickness information. I have tried index function, match function, vlookup function, and combinations of all with no luck.

View 5 Replies View Related

Fill Input Cell With Color Automatically

Sep 8, 2009

I am writing a program in excel spreadsheet and I was wondering how to fill an input cell with color automatically in excel 2007.

I mean that, say I am writing an addition program, I am giving an input numbers in B1 and B2 and i am writing formula in B3 (=B1+B2). I want excel to fill B1 and B2 with yellow/any color automatlically. Only the cells with number input should be highlighted.

View 14 Replies View Related

How Do I Get My Customer Address To Automatically Fill In (cell B)

Dec 11, 2006

i have a an invoice template setup on my computer in excel.

what i would like to know is how do i get my customer address to automatically fill in (cell b) if i select them by customer number (drop down menu in cell a) in an different cell (cell c)

View 9 Replies View Related

Auto-fill To Not Automatically Use The Next Numbered Cell

Dec 29, 2009

How do you make the auto-fill to not automatically use the next numbered cell:

For example:

I want it to fill with every other cell from a different sheet (same column "D") so i would have a cell ='sheet1'$D10 or whatever then how would i do it so it will auto fill every other cell from then on so the first cell below the initial one would copy from the other sheet as D12 instead of D11?

View 9 Replies View Related

VBA Code To Automatically Fill Down And Apply Formula Till Last Cell

Aug 22, 2012

I am using this code and it works fine:

Dim MyData As Range
Dim MyResult As Range
Set MyData = Range("E1:E1000000")
Set MyData2 = Range("F1:F1000000")
Set MyResult = Range("J4")
MyResult.Select
Selection.Formula = "=COUNTIFS(" & MyData.Address & ",""=Kim""," & MyData2.Address & ",""=done"" )"

Is there any way I can change the code so that it automatically finds the last cell as Im using Range("E1:E1000000") and Range("F1:F1000000") because there will not be more than 1000000 entries.

View 2 Replies View Related

Formula For Cell Fill Based On Data In Another Cell?

Dec 20, 2013

How do I write this formulae ??

For cell range M6:AV6 fill with N/R If the data in cell D1 = Wont have

View 5 Replies View Related

Changing Cell Fill Colour Based On Another Cell Value

Oct 2, 2008

I have a table:......

I want to colour in the relevant cells for each ref depending on the numbers in the stage column. So for the first line, the cells in columns 1,2,4&6 need to be shaded in. For the second line, the cells in columns 1,2,3,4,&5 need to be shaded in. I already have a lot of conditional formatting set on the sheet so need to do this with a macro.

I have tried to write something but am having issues with it finding the 1 and shading in the correct column but then jumping out of the loop and on to the next cell.

View 4 Replies View Related

Fill A Cell With A Formula Based On Another Cell

Mar 15, 2007

I need to be able to fill in the day automatically when a date in entered

c1 (i type in) 15/3/07
then in a1 the day i listed by the formula =c1 and formatted to "ddd"

so i only type in the date and it fills in the day cell automatically down the rows are i enter new data

View 9 Replies View Related

Automatically Update A Protected Cell Based On Contents Of An Unprotected Cell

Apr 30, 2009

I am trying to find some VBA that will allow protected cells to be updated when a user enters or selects data in other cells.

For example:

Cell 'A1' starts out blank.
Cell 'B1' has a drop down to select specific items.
Cell 'C1' is the date of the order and is a locked cell.
Cell 'D1' is the date of completion and is a locked cell.
The worksheet is protected to prevent direct changes to cells C1 and D1.

If a user enters any information in A1, then C1 displays the current date.
If a user selects 'Complete' from the drop-down list in B1, then D1 displays the current date. Both of these actions are independant of one another. This format is the same for every cell in the 4 columns indicated above. I thought I was able to do this in another spreadsheet I created a year or so ago but I have not been able to figure out what I did and I do not have the spreadsheet to look at.

View 5 Replies View Related

Automatically Enter Text In Cell Based On Another Cell?

Jul 29, 2013

I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number.

What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).

Table A
Cab Type
Cab No

Indigo
100

Indigo
758

Innova
1544

Indica
1675

View 1 Replies View Related

Automatically Enter Text In Cell Based On Another Cell

Jul 28, 2013

I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number. What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).

Table A
Cab Type
Cab No

[Code].....

View 7 Replies View Related

Fill Down Based On Uppermost Cell

Jul 4, 2013

The attached worksheet explains what I'm trying to do much better than I can.

My data is like Sheet 1 and I need to 'fill' it like Sheet 2.

I have about 5,000 rows over 17 columns. The attached is just an example.

match dates.xlsx‎

View 4 Replies View Related

Fill Cells Based On Another Cell Value

May 1, 2009

refer to attached worksheet. If value in D7 is less than zero; then D8 = 0%
If D7 > 0, then D8 = value in C8, and this value must also be copied into 9 adjacent cells in row 8 from D8 onwards.

View 4 Replies View Related

Fill Value In A Cell Based On User Entry

Mar 26, 2009

I have a dilemma.

1.I want to be able to a have a cell be filled with a certain value when the user enter data in Column C.

2.I know that this can be accomplished by a formula, but my spreadsheet will work my efficiently with a macro.

3.I do not know much about VBA but I believe that I will need a macro for each sheet that fills in the word.

View 6 Replies View Related

Fill In Cells Based On Other Cell Values

Dec 21, 2009

I am looking for a way for Excel to fill in cells in a column that has data sporadically in it. I am importing a text file into excel and saving it as an Excel file.

In the example attached, I need the numbers filled in all the way down to the next number. I don't care about the text, just the numbers. I realize I can copy and paste, but these files can be several hundred rows long and it seems there should be a better way.

View 4 Replies View Related

Fill Down (Copy Down) Based On Cell Number

Feb 11, 2010

I am trying to create a macro to fill Sheet1 cells A1 through P1 down, and I would like it to be filled down based on the number in Sheet2 cell R1.

View 4 Replies View Related

Change The Fill Color Of A Cell Based On Its Value

Jan 20, 2009

I'm using Excel 2003- and I am trying to change the fillColor of a cell based on the value of that cell.

11111122222222233333333344455555555555556666777888

If I use Conditional Formatting I can only use 3 colors, I'd like to use 8 or 9. Is there another way to do this without using the Conditional Formatting?

I'd like the result to look something like this-

11111122222222233333333344455555555555556666777888

I've looked at the similar threads in this Forum, but I couldn't find exactly what I needed.

View 9 Replies View Related

Automatically Color Fill Rows Based On Changing Column Information

Jun 24, 2009

I would like to automatically color fill a series of rows based on like information from a single column. When the information in the column changes then the rows would either stop filling (this would be best) or fill with a different color until the information changes again.

Summary: series of alternating rows would either be filled or unfilled based on changes from the column information.

Hope this isn't too confusing. Below is an example except I would want the cells filled, not the text or numbers to change. The highlight is changing based on the changing of the numbers.

ABCD 12345
ABD 12345
ABCD 12349
ABDF 12349
ABCD 12358
ABF 12358

View 9 Replies View Related

Find The Data In Some Rows That Match With One Cell And Automatically Fill The Data

Aug 17, 2009

I want find the data in some rows that same with one or more cell and automatically fill the data. And for more details, I have attached the examp file (Examp.xls).Antoni

View 3 Replies View Related

Set Cell Fill Color Based On Conditions In Two Cells?

Nov 22, 2012

I want to highlight the cell of Column 'A' of excel only when it does not contain the text like "Verify", "Validate" or "Evaluate" in its content if, the value in corresponding cell of Column 'B' holds the value 'Y'. Secondly, the column 'A' can't contains the words like 'Verify', 'Validate' and 'Evaluate' if the corresponding cell in Column 'B' holds value 'N'. So just need to highlight those discrepancies if its there.

Column A
Column B
Expected Action

Press F3
N
Its Fine

Verify this..
Y
Its Fine

this....
Y
Need to Highlight Cell of Column A as Value in Column B is Y but the column A does not contain any value like "Verify", Validate" or "Evaluate"

Verify This.
N
Need to Highlight Cell of Column B as the Value of Column A contains words like "verify", "validate", "evaluate" but corresponding cell value in column B does not hold value "Y".

View 3 Replies View Related

Fill Multiple Cells Based On The Result In One Cell?

May 31, 2014

When I enter barcode X in cell A1, I want B1 to say supplier and C1 to say product name and D1 to say package quantaty etc.

And if I enter barcode Y in cell A2, I want B2 to say different supplier, and so on, hopefully you get the picture.

View 7 Replies View Related

Auto Fill A Cell With A Value Based On Pre-defined Range

Mar 19, 2013

A have three columns with "Kilograms range" and corresponding value.

A========== B========== C
KG From====-To======= Predefined Value

what formula will fill up the cell with the predefined value automatically based on the range, after a kilograms are entered in a different cell as explained in the attachment.

View 2 Replies View Related

Formatting Cell To Fill Color Based On 2 Of 3 Values?

Jul 23, 2013

I'm trying to discover the best way to accomplish formatting a cell by filling it a certain color based on 2 of 3 criteria of other cells.

Column A has the title of the field. Cells B1:D1 have one of 3 values: Nothing/blank, Complete, or x. If all of the x's are gone within the range of B1:D1, I'd like to automatically format cell A1 to fill in Blue (or any color).

A1__________________B1_________________C1_____________D1
Generic Name______Complete_______________x_____________

If the 'x' in C1 is changed to the value of 'Complete', I'd like A1/Generic Name to be filled in with a color.

View 8 Replies View Related

Excel VBA Fill Dates Based On Number In A Cell

Jul 3, 2014

I am looking to use a VBA routine so when a Date is added in a cell and a number is in the cell below on running the routine I would like the Date to be filled by serial number to the cells to the right. So if D3 has a date in the cell say 03 July 2014 and E3 has the number 10 then to the right of D3 it fills the Date's 10 Cells to the right 03 July 2014 through to 13 July 2014.

Code:
Dates
03/07/2014

Amount
10

View 7 Replies View Related

Automatically Fill In Column When Certain Cell In Column Changed

Jun 18, 2009

I am trying to have some automation to my WS and what I want to do, is if a certain column (column 104) is changed, it will fill out that column with the data entered as long as the account is the same (column 5). Here is the code I tried, but realized very quickly, it puts me into a loop. This is being called by a change worksheet fuction

If Target.Column = 104 Then
If IsEmpty(Target) Then
Else
testacct = Cells(Target.Row, 5)
temptest = testacct
s_TempSwitch = Target.Value
Testoffset = 0
Do While temptest = testacct
temptest = Cells(Target.Row + Testoffset, 5)
Cells(Target.Row + Testoffset, 104).Value = s_TempSwitch
Testoffset = Testoffset + 1
Loop
End If
End If

View 3 Replies View Related

Changing Fill Colour Of 2 Other Cells Based On Another Cell Outcome

May 29, 2014

I need to fill 2 other cells with varying colours dependant on what is chosen within another cell.

I have a drop-down list in cell A2 to select either ON SITE, ACTIVE or CANCEL.

What I need then basically is...
if A2 equals 'ON SITE' then fill other two cells (A3 and B1) GREEN
if A2 equals 'ACTIVE' then fill other two cells (A3 and B1) YELLOW
if A2 equals 'CANCEL' then fill other two cells (A3 and B1) RED

[File attached]

View 8 Replies View Related

Changing Fill Colour Of Cells Based On Other Cell Inputs

Jun 20, 2014

I have a calendar set up with dates going along P6:CU6. Column C9:C27 has various status' for the job such as "Complete" or "In Progress" etc. Next to that in rows D and E I have start and end dates for the job. What I am trying to do is change the fill colour of the empty cells that are in line with each job, so that between the correct dates they are the corresponding colour to the status. So a complete job on row 9 that started on 26/05/14 and finished on 28/05/14 would have three green cells along Q9, R9, and S9.

I have tried an IF/AND/OR statement which looks like this:

=IF(AND(Q6>=D9,Q6<=E9),OR(IF(C9="Planned","P",""),IF(C9="In Progress","IP",""),IF(C9="Late","L",""),IF(C9="Complete","C","")),"")

I am getting a #VALUE! data type error, I have tried reformatting the cells to various date formats but no luck so far. This could be because my dates are set up as =P6+1 etc. but I am not sure. The error only occurs when the cell falls within the dates, otherwise it remains blank.

I intend to hide the value in the cell and use conditional formatting to change the cell colour based on the hidden input.

Once this is working I also need to take weekends into account, column G has any 2 value combination of Y and N to say whether the employee is working Saturday, Sunday or both. Row 7 has a "1" value underneath every Saturday and a "2" underneath every Sunday. I can imagine how this would work but combining it with the above formula could be complicated.

View 1 Replies View Related

Delete Columns And Rows Based On Cell Fill Color

Jan 31, 2014

I am a locksmith and attempting to write a spreadsheet app. for my line of work. The output page will use columns A-G and rows 1-?10000? depending on the size of the system. If a 5 pin system is requested then columns A+B will be blacked out. 6 pin system A is blacked out. 7 pin system nothing blacked out. Also, if any cell matches the master key that was input, that cell is filled with red. I know, confusing.

Basically, I am trying to remove the blacked out columns automatically, and to remove the enitire row is any cell in that row is filled with red. Then to remove blank lines.

View 2 Replies View Related

Dynamically Fill Range Of Columns Based On Value Of Cell In Another Sheet

Feb 24, 2014

I wanted to enter value in sheet1 on A1. Columns in sheet2 from B1 until the value entered in sheet1.A1 should be automatically filled.

E.g.

Sheet1.A1=5, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3, Sheet2.B4=4, Sheet2.B5=5.

if Sheet1.A1=3, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3.

if Sheet1.A1=7, then Sheet2.B1=1, Sheet2.B2=2, Sheet2.B3=3, Sheet2.B4=4, Sheet2.B5=5, Sheet2.B5=6, Sheet2.B5=7

etc.

View 2 Replies View Related

How Do I Fill In A Cell Based On The Relationship Of The Number Within A Range Of Numbers

Feb 6, 2009

This is a spreadsheet for a real estate office. The boss gave me a spreadsheet that he created to give a seller an idea how much money he will walk away with at closing. The spreadsheet includes all of the pertinate numbers but there is one item that he would like to have filled in automatically. When selling a house, you use a title service that charges a fee based on the price of the house. So, for example, If the house sells for $0 to $50,000, then let's say the fee is $112. If the house sells for $50,000 to $60,000, then the fee is $118. If the house sells for $60,000 to $70,000, then the fee is $125, and so on up to 1.5 million.

The boss' spreadsheet includes 5 different selling price scenarios, which I guess doesn't matter since you do the first one and the rest follow the same pattern.

So how do I automatically fill in a cell based on how one number falls within a range of other numbers? The fee schedule will be within the same spreadsheet, if that matters.

Ideally, I think they should be separate files, but this will be used in various locations as different realtors take it home or use it on their laptops.

View 9 Replies View Related

Fill Range With Data Meeting Conditions Based On Cell Value

Apr 23, 2009

refer to attached worksheet.

I need a way (Non-Macro please) - where if a condition is met, then fill a range with a particular value. The attached spreadsheet has a sample with explanation.

View 9 Replies View Related

Fill UserForms Controls Based On Active Cell/Row/Column

Jun 22, 2006

I am attempting to write an Excel Macro that would allow me to Click on a particular row and have the fields in my form fill with the data in the columns of the row.

I am fairly new to Macros and VBA, but know that this has got to be a possibility.

View 9 Replies View Related

Fill Table Based On Matching Cell Values & Export

Dec 21, 2007

(refer to attached workbook)

For what I'd like to do, the attached workbook actually represents 2 or more workbooks. The 'Project-PO Report' tab is a sample of what will be several workbooks/reports that will be generated from the data in 'POTASK'.

The 'CMD_BUTTON' tab represents how I plan to use a command button " IMPORT DATA" to import the data into this workbook, then use "RUN PROJECT-PO-REPORT" to call the MACRO to achieve my objective,as stated below. (Originally,this workbook was about 8mb, so to get this under the size for attachment, I just copied the bare minimum of what I believe would be needed to assist me, and so there's no buttons or macros or dynamic name ranges, as there will be...)

Here's what I want to do: ...

View 3 Replies View Related

Fill Conditional Cell Values Based On Unknown Number Of Rows

Dec 15, 2009

I have a set of data in column R, with an unknown number of rows that looks like this

Days Late
-28
150
3
16
41
.
.
.

and I have written a script to add an adjacent column "S". I want to fill column S with conditional values based on the value of column R, sorted into categories such as "On Time", "Less than One Month Late", etc. Here is what I have so far, it doesn't work:

View 4 Replies View Related

Changing Fill Color Of Autoshapes Based On Cell Numeric Values

Jun 10, 2006

how I can change the color of an autoshape based on a value in a cell?

View 4 Replies View Related

AutoFilter Automatically Based On Cell Value?

May 12, 2008

I am looking for a way to have some VBA code running in the background of a worksheet.

I would like the autofilter criteria to be based on a cell reference which can change based on what this cell value is?

View 6 Replies View Related

AutoFilter Automatically Based On Cell Value

May 12, 2008

I am looking for a way to have some VBA code running in the background of a worksheet.

I would like the autofilter criteria to be based on a cell reference which can change based on what this cell value is?

View 3 Replies View Related

VBA To Fill Cell Values Based On Adjacent Cell Values

Jun 5, 2014

I request you to write a code for me to fill the cell values as "Not Applicable" in Column "AZ", if the "B" Column cell values = "Justified", "Approved LSAR" & "Approved SDAR".

I have attached the work book of what I am trying to accomplish.

View 14 Replies View Related

Select Row Based On Cell Criteria Remove All Formulas From Row And Change Fill Color

Apr 23, 2014

I have a worksheet that when a row changes based on the value of column B, I want to remove all of the formulas found in the row but keep the existing values, and then change the color of the row.

In the sample file attached, when the value is "Closed", that row will keep the existing values and then it gets grayed out. Rows that are still marked "Open" need to retain the formulas in case other information changes.

I have tried copy/paste special using autofiltering but that doesn't work because of the hidden lines. This file changes on a daily basis and I need a quick way to update the file.

SampleFile.xlsx

View 1 Replies View Related

ADVERTISEMENT