Cell That Contains A Zip Code And Populate Another Cell

Jan 19, 2007

I am trying to create a formula that will reference a cell that contains a zip code and populate another cell with the appropriate technicians ID.

It's simple with one tech covering only one zip code

View 14 Replies


VBA Code To Populate A Cell Automatically Whenever Another Cell Is Filled In Manually?

Mar 29, 2014

I have a spreadsheet with 6 hidden columns (B to G). Rows 1 to 14 are frozen and have data that comes from another work book and these rows will be protected. The user will enter data from H14 to U14 and then H15 to U15 for the next row and so on down the sheet. The number of rows of data over a week is variable, a minimum of 21 rows (3 per day) but no maximum.

When the user starts entering new data in the column range H to U I would like to automatically populate the 6 hidden cells on that row with information from particular cells in protected rows 1 to 14. For example B14 would populate with the value from I4, C14 would populate with the value from I5, D14 from I6, E14 from I7 and so on whenever someone enters a value anywhere from H14 through to U14.

I can understand that a worksheet change event would be useful to do this but I guess then it wouldn't want to run every time each cell is populated so I think if it had to activate on a single cell change then the cell in column L would be best. Also, as I understand it, there can be only one block of code per sheet that operates on a worksheet change event, have I got that right? If that is the case then I assume all the code to populate the hidden cells on each row will need to be in this block of code.

View 8 Replies View Related

Populate A Cell Based On Conditions Of Other Cells W/out Putting A Formula In The Cell

Oct 10, 2009

Is there a way to make a cell populate certain text based on conditions of other cells without putting the formula in the cell you want to populate. So that someone could type other text into the cell if the conditions were not met?

View 14 Replies View Related

Using A Formula To Populate A Cell With Certain Data Based On Content Of Another Cell?

Jul 7, 2014

I am currently trying to create a spreadsheet whereby if I enter certain text in a cell in Column A on worksheet 1 that correlates with text in a cell in Column A on Worksheet 2, then the description in Column B in Worksheet 2 is entered into Column B on worksheet 1.

For example, if worksheet 2 has the following:

Column A Column B

and I enter XXXX in column A on worksheet 1, I want Column B on worksheet 1 to automatically enter PRODUCT 1.

View 5 Replies View Related

Auto Populate Cell With Static Date As Another Cell Is Populated

Jan 25, 2008

I have used the following =IF(ISBLANK(Q6),"",(NOW())) & =IF(ISBLANK(Q6),"",(Today())),
but when the excel file is closed and opened the date changes to now or today. How can I make the date stay and not change?

View 4 Replies View Related

When One Cell Is Populated How To Auto-populate A Cell With Date

Jun 27, 2013

I am trying to make a date auto populate when an entry is made into a specific cell.


Cell H has a drop down list of staff names who will be assigned to a project, once a name is selected from the drop down box:

Cell I needs to auto-display that days date

is this possible with just a simple formula?

View 6 Replies View Related

Populate Cell With Value (from Another Cell) As Per Count In Another Cell?

Jan 3, 2014

I want to populate cell with a value(from another cell) as per count in another cell.

Say ex.
1. CELL A1 having Value 1000.
2. CELL B1 having Value 10.
3. Column C, should be updated with value of A1 cell as B1 cell times. How to do that.

View 1 Replies View Related

Getting One Cell To Populate Another

Dec 4, 2009

I want to do, if possible is have the daily sheets pull some of their data automatically from the monthly sheet as soon as it is entered.

View 2 Replies View Related

Populate Cell Using VB

Jun 25, 2008


It uses DDE to talk to a program called MetaTrader and this places 'Live' price quotes in that cell.

1.User selects currency pair in Cell C4
2.I need code to place a formula in Cell F4 constructed as follows:

=MT4|BID!cell c4m

I have been trying to get this work for weeks now but with no joy
Whatever i try to do - it only places the above as TEXT in that cell, even if i open a new sheet and cells are set to General format, however - when i type the above code in a cell - i have no problems and start getting price data straight away.

View 9 Replies View Related

Populate One Cell Based On Two Others

Apr 9, 2014

I am trying to populate a field in a Sheet 1 that is dependent on two other drop down fields that are chosen. Some of my data has the same names but different equipment.


Jim Jones

[Code] ....

Basically, I want to choose a name from say a drop down, then an equipment pc from drop down, and have the other field populate for say the Serial Number.

View 4 Replies View Related

Text From One Cell Populate To Another

Feb 16, 2009

I am attempting to copy Text from one cell and populate to another, e.g.

A1 = Excellent
A2 =
A3 = Good
A4 = Bad

If i type ='Sheet 1'!A1 in the cell on my second sheet it populates fine, however i need to be able to ignore blank cells as well

View 9 Replies View Related

Populate A UserForm- According To The Row The Cell

Mar 6, 2008

I have some textboxs and some comboboxs, on a user form I want them to populate according to the row the cell is selected on.


cell c15 is selected,

UserForm1 Textbox2 populates with value of A15
UserForm1 Textbox1 populates with value of D15
UserForm1 Combobox2 populates with value of F15

And is the user changes a value I need it to update the cell.

View 10 Replies View Related

Cell To Automatically Populate

Mar 26, 2008

i am working on a spreadsheet that includes a large amount of statistical numbers / records. one part includes a win / loss column and the very next column i am entering the final score for each game. to max this easier to comprehend, there are only 3 columns. 1st column lists my opponent, the 2nd lists, with just a red L for loss, or a green W for win, and the 3rd column has the final score. (my score is always first, regardless of whether i won or lost the game.)

John W 23-10
Paul L 17-25
Terri W 10-7

This is what i'm searching for: (and the easiest way possible b/c i'm not familiar with macros / visual basic, etc.) ... Once i enter the score: ##-##, I would like the "F" (final outcome) cell to automatically populate either a bold red L for a loss, or a bold green W for a win. My scores are almost never 3 digits, so they would almost always be ##-##. if u need me to provide more info,

View 12 Replies View Related

Vlookup To Populate A Cell

Sep 9, 2008

I am trying to use vlookup to populate a cell. My lookup cell is a string of text. My refernce table contains a list of words that I want populated if it is contained in the text cell. THe results I am getting is #name


View 9 Replies View Related

How Can I Duplicate Or Populate The Cell Below With What Is Above It

Nov 14, 2008

If I have several entries similar to this:

CollectionsDates and Amounts
Errors in Payment Arrangement
Errors with Cut In

CollectionsDates and Amounts
CollectionsErrors in Payment Arrangement
CollectionsErrors with Cut In

View 9 Replies View Related

Populate Cell With Computer Id

Mar 3, 2007

is it possible to populate a worksheets cell on opening a workbook with the idenification of the computer opening the workbook?

View 4 Replies View Related

Set Array From Cell A5 To Last Row To Populate Combobox

Nov 7, 2012

I have a VBA form and on form initialize I want to populate a combo box… My array to populate it with could be a massive list so I need to set my array before it populates

I have this code so far but I need my array to be from A5 to the last row in sheet 1

I know how to set an exact range but not one that changes.

Dim myArray As Variant
myArray =
With Me.ComboBox1
.List = myArray
End With

Here is a sample of the data I need to populate in the combobox.


[Code] ....

View 8 Replies View Related

VBA Auto Populate Cell Through Lookup

Mar 25, 2014

I would like to enter a name in E11, and then have G11 populate the name of the company that person belongs to, from a different sheet.

If the person is new, the company name entered into G11 should create a new column on the Companies sheet.

I've attached a dummy sheet which should make it more clear.


View 9 Replies View Related

Populate A Cell With Text From 3 Cells?

Jan 24, 2014

I need to be able to populate a cell with text from 3 possible cells, two will have the text "none" in them, the other text cell is the one i need to populate in another cell.

View 3 Replies View Related

Populate Cell Based On Worksheet Name

Mar 18, 2009

I have a macro that copies data from 6 different worksheets into one summary worksheet - based on certain criteria - I need a way to note on each row of the summary sheet which worksheet it was copied from. Each worksheet is specific to a salesperson, so ideally I would like that salespersons last name to populate in column B on the summary page for each row of theirs that is copied over....here is my current macro I use to copy the data: (this code is repeated for each sales persons sheet - "Blankenship", "Dew", etc...) I have attached a scaled down version of my file.

View 2 Replies View Related

Populate Cell Based On Two Criteria?

Aug 2, 2013

I have a list of teams, and beside them I need a calculation to be filled.

The criteria is based on a cell reference (a month which can be changed from a drop-down in BM2) and also the name of the team.

dummy 16.xls

View 5 Replies View Related

Populate Row If Cell In Column A Is Blank?

Feb 20, 2014

I want to populate a row with text "OFF" if a cell in column A is blank, I need the text to be from column F to Column S, I have a bit of code that finds the blank cell in column A and populates the cell in column F, modifying it to extent to column S.

View 2 Replies View Related

Automatically Populate Another Cell When One Is Updated?

Apr 27, 2014

I have a spreadsheet where vehicle milage is entered at the end of each month. On another sheet I have the vehicle fleet numbers and the the months along the top. What I need to happen is; when the mileage cell is updated I need the cell in the other sheet to be automatically populated, when the mileage is updated the next month I need the next cell(February)to be populated with the new milage and so on. The aim is to calculate monthly milage for each vehicle without having to enter the date at the beginning and end of the month.

Everyone I work with is completely computer illiterate and only knows how to enter the data the same way they always have(just the once at the end of the month) changing it up will only cause issues.

View 1 Replies View Related

Populate Cell With Value That Appears Most In Column With VBA?

Mar 5, 2014

The formula I'm trying to use is


And it works as I need it to returning the value that appears the most from L31 to L6621. My problem is the number of rows will continue to change. So I tried something like this

Sub ARBM()
Dim lr
With ActiveSheet


But I get a compile error with expected end of statement. How else can I write this?

View 4 Replies View Related

Using Cell Values To Populate With Characters?

Dec 21, 2008

I am trying to find a way to populate a cell with spaces (like " "). But I want to populate a cell based on a number in another cell.

For example, if cell A1 has a value of 7 in it, I want to make another cell have seven spaces (or seven letter Z's, or anything), but I can't figure out how to do it. Then I want to use that equation to do any number of spaces based on the number in the cell, whatever it is.

View 4 Replies View Related

Populate Cells Based On Value Of Another Cell?

Apr 6, 2013

I have a table in excel with some data to create labels, but these labels must be repeated according to the number of volumes. Example: I have a delivery for X and such delivery has 5 volumes, need to create 5 labels just changing the volume number: 1/5, 2/5, 3/5, 4​​/5 5/5.

I would enter a value in "D1" after running the code, in column "A" shall be filled as follows.

D1 = 7
A2 = 1/7
A2 = 2/7
A2 = 3/7
A2 = 4/7
A2 = 5/7
A2 = 6/7
A2 = 7/7
If "D1" equals 3 then
A2 = 1/3
A2 = 2/3
A2 = 3/3

View 4 Replies View Related

Use A Drop Down List To Populate Cell

Apr 25, 2007

Is it possible to use a drop down list to populate cell elsewhere on the same worksheet?

View 9 Replies View Related

Populate Empty Column With Value From A Cell

Aug 5, 2007

I need a macro to do something very easy. I have blocks of data in an excel worksheet separated by one column. The First block begins in column B and ends in col G. Next block begins in column H and ends in L.

I'd like to copy the value from the first cell in the start of each block (b1) and paste it in the left column seperating each block (left empty column - a1) all the way down to where the data in that block ends (b60), and do this for the next column. So in the above exmaple it would populate column A (range a1:a60) with the value from cell B1.

The number of columns is the same but the number of rows vary. The value to be copied is always in the first row and first colunm of where a data block begins - so in the case above - b1, h1 etc.

View 9 Replies View Related

Macro To Populate Cell A Or Ignore

Jan 30, 2008

I'm in a situation where I need to find a workaround for a circular argument. I've decided that having a macro to run would work rather than have a formula in the cell I want populated.

I need a macro to either completely ignore the contents of A31 or to change A31 based on the contents of B31. Sometimes there's a B32. Sometimes there's a B667. In which case, this would need to work for all cells A31-A667.

If B31 contains CHERRY or PEACH I want A31 to be altered to say TASTY. IF B31 contains SLIME I want A31 to be altered to say NASTY. If B31 does NOT contain, CHERRY, PEACH, or SLIME I need whatever is already in A31 to remain unchanged.
This would need to continue down the rows until there are no more contents in column B.

Best guess:
I like said - I'm awful. All I could come up with is an IF statement that isn't even complete.

that doesn't change the contents of the cell))

But that's something I would have in cell A31 rather than a macro

View 9 Replies View Related

Offset Cell To Populate The Text Box

Mar 11, 2008

How can I make this statement take the value from the Offset cell to populate the text box and not take the value from the text box to popluate the Offset Cell?

With txtBoarded
ActiveCell.Offset(0, 1) = .Value
End With
This code is in the user form initialize code.

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved