# HELP with macro config

I would like to type an account number into cell B15 so if B15= (10023) then the other cells must automaticaly display as follows B12=name & G12=po box 1234 G13=city G14=postal code B16=vat nr and G15= terms
If I type a difrent number into B15 The other cells must change acordingly
this is for excel 2007

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Posted on Jul 20, 2008

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Excel cell replacement

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!\$A\$1:\$B\$5,2,false)
This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

### NED HELP TO CONFIGURATE DISPAY FOR STAIRMASTER 4400cl

Display reads CONFIG RQRD or NTM CONFIG RQD on Stairmaster Equipment Probable Cause The message CONFIG RQRD or NTM CONFIG RQD appears when the console needs to be configured for the machine type it is installed. This message is common when the console has been replaced or if the settings have been changed. Message is commonly seen on various Stairmaster equipment such as bike models 3000CE, 3300CE, 3400CE, 3600RC, 3800RC and 3900RC; stepper models 4400PT, 4600PT, 4400CL, 4600CL and SC916; stepmill models 7000PT and SM916; elliptical model ClubStride 5100.
Corrective Action
• Make sure the unit is in an "idle" state. "Idle" state means the console is not displaying an error or any message that requires data input. The display should basically be freshly powered up, scrolling the EKG or welcome message
• Configure the console for the proper machine type by pressing Level UP, 80, ENTER
• Using the Level UP or Level DOWN keys, scroll through to the proper machine type (Bike, Elliptical, Stairclimber or Stepmill)
• Once the proper machine type is shown on the display select the machine type by pressing ENTER
• This completes the steps necessary when your Stairmaster display reads CONFIG RQRD or NTM CONFIG RQD
Stairmaster Console Message CONFIG RQRD or NTM CONFIG RQD

Feb 20, 2012 | Stairmaster Exercise & Fitness

### Config required on screen, I know there is a series of numbers to enter to remove this ...I just don't have the manual. Can you help ?

Display reads CONFIG RQRD or NTM CONFIG RQD on Stairmaster Equipment Probable Cause The message CONFIG RQRD or NTM CONFIG RQD appears when the console needs to be configured for the machine type it is installed. This message is common when the console has been replaced or if the settings have been changed. Message is commonly seen on various Stairmaster equipment such as bike models 3000CE, 3300CE, 3400CE, 3600RC, 3800RC and 3900RC; stepper models 4400PT, 4600PT, 4400CL, 4600CL and SC916; stepmill models 7000PT and SM916; elliptical model ClubStride 5100.
Corrective Action
• Make sure the unit is in an "idle" state. "Idle" state means the console is not displaying an error or any message that requires data input. The display should basically be freshly powered up, scrolling the EKG or welcome message
• Configure the console for the proper machine type by pressing Level UP, 80, ENTER
• Using the Level UP or Level DOWN keys, scroll through to the proper machine type (Bike, Elliptical, Stairclimber or Stepmill)
• Once the proper machine type is shown on the display select the machine type by pressing ENTER
• This completes the steps necessary when your Stairmaster display reads CONFIG RQRD or NTM CONFIG RQD

Stairmaster Console Message CONFIG RQRD or NTM CONFIG RQD

Mar 16, 2011 | Stairmaster FreeClimber 4600CL Blue...

### My phone is locked , and now asked me for my Blur account username and password ....but i forgot ....i got the motorola CLIQ

Before you can attain your Motorola CLIQ's unlock code you will need the IMEI number on it. You can find the IMEI number by simply typing *#06# and hitting enter. This number is unique to all GSMphone and will help calculate your unlocking code. Once you have your unlock code you are ready to begun the Motorola unlock instructions posted below.

Here are the steps to unlock your phone:
Unlock Motorola CLIQ (SIM Unlock)

1. Reboot your Motorola CLIQ with an unaccepted SIM card in.
*If the display reads "Enter Special Code", enter the unlock code and press "OK"
*If the display does not read "Enter Special code":
2. Press and hold the * key until an entry box is displayed.
3. Type *, #, 3, 2, # and press "OK"
4. Enter your Motorola CLIQ's unlock code and press "OK."
5. Your Motorola CLIQ should now display either "Completed" or "Deleted"

Jan 01, 2011 | Motorola Mobility CLIQ Cell Phone

### I have not use the internet on my nokia 3110c phone when i start config.setting then personal config. setting, i can not create ADD NEW. when i select the ACCESS POINT then display show me Cannot Add New...

I have not use the internet on my nokia 3110c phone when i start config.setting then personal config. setting, i can not create ADD NEW. when i select the ACCESS POINT then display show me Cannot Add New Account.Memory full.

Oct 28, 2010 | Nokia 3110 Cellular Phone

Menu - Settings - Configuration - Personal config. sett.:

MEdia Net
Account name: MEdia Net
Homepage: http://device.home
Use pref. access pt. : No
Access point settings
Proxy: Enabled
Proxy port: 80
Data bearer: Packet data
Bearer settings
Packet data acc. pt. : wap.cingular
Network type: IPv6
Authentication type: Normal
User name: wap@cingulargprs.com

My multimedia messages
Account name: My multimedia message
Use pref. access pt.: No
Access point setttings
Proxy: Enabled
Proxy port: 8080
Bearer settings
Packet data acc. pt. : wap.cingular
Network type: IPv4
Authentication type: Normal
User name: wap@cingulargprs.com

Menu - Messaging - Message settings - Multimedia messages - Configuration sett.
Configuration: Personal config.
Account: My multimedia message

Nov 12, 2009 | Nokia 6300 Cellular Phone

### Can anyone help me. I want to write a macro that goes to a cell and waits for the user to input something then moves to the next cell (down) when the user presses enter and repeats the process until the...

There is function called INPUT, which opens an input window and waits for user input. The input is stored in macro cell and you can refer to it later. To get to the end of (or top of) use SELECT.END and you will go from the active cell to the first blank cell up, down, left or right depending on the argument you enter. These are Macro Version 4.0 functions and there are similar functions in VBA RHands

Jun 08, 2009 | Microsoft Office Excel 2003 for PC

### Macro code for copying a range of cells from one Excell w/sheet t

You did not respond to my claification request. Here is some code that might help, it copies a selection of cells going down until an emty cell is found and across until an emty cell is found. This is form an earlier version of office but should comeclose to woring in 2007.

Sub copyrange()
'
' copyrange Macro
' Macro written by Royal 11/22/2008.
'

'save the return values
wksname = ActiveSheet.Name
searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)
Worksheets(1).Activate
findfor = "A1"
On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
If findfor = "A1" Then
erwks = ActiveSheet.Name
Sheets(wksname).Activate
er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")
Exit Sub
Else
findfor.Activate
End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries
begcl = ActiveCell.Cells.Column
begri = ActiveCell.Cells.Row
'search amaximum of 1000 rows and 676 columns
endri = begri + 1000
endcl = 26 * 26
maxrow = 0
maxcol = 0

For col = Cells.Column To endcl
If Cells(begri, col) = "" Then
maxcol = col
col = endcl
ri = endri
Else
ri = begri
End If
For ri = ri To (Cells.Row + 1000)
If Cells(ri, col) = "" Then
If ri > maxrow Then
maxrow = ri
End If
ri = endri
End If
Next ri
Next col

maxrow = maxrow - 1
maxcol = maxcol - 1

'copy the selected area
crnge = begcell & ":" & endcell
Range(crnge).Select
Selection.Copy
'go back and paste it in
Sheets(wksname).Activate
Range(returncell).Select
' use this if yo want to paste formulas etc.
'ActiveSheet.Paste
' use this code if you want to paste values instead of formulas etc.
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range(returncell).Select

Nov 20, 2008 | Computers & Internet

### I need to Have a timer created in excel

Hi, I was looking to create a timmer. with stop and start option on excel.I have found the anser withyahoo group answers, that was help full and free, i got the VB macro programee. if you still can help me , here is the query,

I need a timer with stop and start option,

when i click on the star button i want the present time coming up on a cell(any cell) and when i click on the stop, i need to get the presen tme on the other cell, i need to clculate the time spent between the 2times.

i also need the time geting accumalated in the different sheet to calculate, how many times i have clicked and the difference.

Regards

Rochboy

Apr 03, 2008 | Microsoft Access 2000 (077-01277) for PC

#### Related Topics:

126 people viewed this question

Level 3 Expert

Level 2 Expert