How to set it in Excel to enter 3 in A1, and the content of row 3 B2, B3, B4 will automatically ap

You're asking about the data in the three columns of B1, C1, and D1 that are automatically sent back after entering A1.

In this case, use.

vlookup is a lookup reference function.

Suppose Table 1 is a list of the raw data.

The format is: column A is the number, column B is the number China, column C is 500, column D is 250...All the way up to line A100, then in Table 2, column A, is the data entry field with 1.

Then the b c d column can be used to find 1 in table 1 and send back the data in the b c d column of table 1!

Formula = vlookup (Find target, find source target range, number of columns after target range, logical value).

The formula is written in column B of Table 2, the search target is column A of Table 2, and the search target range is column A1:D100 of Table 1.

The number of columns (numbers) after the target range is the difference between column A to column C in Table 1: A to B is 2, A to C is "3", and so on! For example, Table 2.

a1=1 then in b1=vlookup($a 1,"Table I"$a$1：$d$100，2,false)

c1=vlookup($a1，"Table I"$a$1：$d$100，3,false)

d1=vlookup($a1，"Table I"$a$1：$d$100，4,false)

Then just drag the b1 c1 d1 formula down.

In b1, enter:

vlookup($a 1,$a$2:$d$4,row(),0) is pulled to the right to d1

Enter 1, 2, 3, 4 in A1 to try.

You're talking about automatic filtering, right?

Select all cells, click Data Menu - > Filter - > Auto Filter.

Don't know what you mean. You try "Data" - Filtering, "Auto Filtering" or Advanced Filtering to see if that's what you want.

Point the mouse at the bottom right corner of the cell, and hold down the mouse to pull down or right when the cross appears.

First enter =A1 in B3, so that whatever data you enter in A1, it will be the same in B3.

Enter =a1 in b3 and you're good to go.

Use the form control or set f(x)=a1 in b3

Type "=A1" in b3 and you're done.

...... B1, B2, B3, B4, enter the formula:

A1 That's it.

Is that so? I'm afraid this can't be done, excel isn't smart enough to determine which cell to quote a number based on the number of times you type.

There are three steps:

1. Let the B1=A1 formula be used. After selecting b1 with the mouse, enter =a1 in fx.

2. Let b2=b1, and the formula usage is the same as above.

3. After selecting B2, place the mouse in the lower right corner of the marquee, and when the mouse becomes a black cross, pull down to the position you want.

The effect is as you say.

Question: How to implement Excel every time you enter a new number in A1, enter in B1, B2, B3, B4...is automatically filled in with a new number each time you enter in A1:

The first time enter 23 enter in A1, B1 will automatically fill in 23, the second time enter 2433 in A1, B2 will automatically fill in 2433, the third time enter 555 in A1, B3 will automatically fill in 555...And so on.

With macros, I think it can be used to solve the desired effect. (Set the macro activation mechanism to a cell such as A1 to determine the input of data.) After A1 input data, the macro is activated, and after execution, the result is output to a new cell, and at the same time, if there is a value in the existing cell, the next cell is filled, and of course, it can also be judged according to the value comparison, time order, etc.

I am not familiar with macro, so I can only throw bricks and lead jade, and ask the master to give a plan.

Actually, I'm thinking about making excel itself a revolution

Make the Excel function have the function of actively assigning values to new cells, that is, after a formula is entered, the function in the formula is executed, which is equivalent to a macro (program) running, so that there is no need to fill in the formula one by one in the area that accepts the data. It is also possible to store some formulas that simply refer to the replaced as one (this is also similar to an array formula), and in the accepted data area, the result is a pure value, or just a temporary calculation of the desired value when needed. This saves time and storage space.

It's a pity that at the moment, the content of a cell filling, which is either a formula or a value, is not allowed to have both, and I feel that this needs to be changed.

At the same time, you can also consider using cell attributes to work with formulas (or even partial equivalents), a cell can have a default execution attribute and define an execution formula.

If you want to enter A1 to B1, A2 to B2, .,This can be done as simply as follows:

Enter the formula in B2: =A1

Select column B, or B1 plus the local area where you want to place data, and press Ctrl D (you can also double-click or drag when the black cross is displayed in the lower right corner of B1, note that there is sometimes a difference between double-clicking and dragging); You can also f2 and then ctrl enter.

Notes: excel fixed inside one cell, locked, macro.

* Use the list.

Select the second column and press CTRL-L to create a list. Then altvt-click on the list toolbar. altlo (List Toolbar - Record Sheet), which allows you to enter content in a record box and automatically add records.

You first need to create a table that corresponds to all ** and all contents, for example, build in sheet2 and enter back ** in column A of sheet1, and enter the formula in b2

if(and($a2<>"",countif(sheet2!

A$a:$a,$a 2)),vlookup($a 1,sheet2!).$a:$c,column(b1),)""Pull right to fill column C, and then pull down to fill several rows together.

du] 3-in-1 Original White Coffee Zhi",if(a2="00100102","[Old Town] 3-in-1 red sugar white coffee",if(a2="00100103","[Old Town] 3-in-1 fruity white coffee",if(a2="00100104","[Old Town] 2-in-1 White Coffee (with free candy bar dao).",if(a2=100105,"[Old Town] 3-in-1 white milk tea","")))

If the full name of those products already exists in the worksheet, then you don't need to enter the full name yourself when the formula, just select the reference with the mouse, or use the lookup function.

The product code is A1

Column d is the query column.

d1: Enter the 100101 of the code to be checked

e1 input = if(d1<>"",vlookup(d1,$a:$b,2),"")

B1 input formula: =a2-a1

Move the cursor to the bottom right corner of the cell, and when it turns into a black cross, drag it down!

It's as if your brain can't turn around and tell you another way.

Click on column B with the mouse, then column B will be all discredited, and then type =if(a2="","",a2-a1)

Press the Ctrl key on the keyboard and then click the enter key, it's OK When you enter the number in cell A1, nothing will be displayed in cell B1, when you enter cell A2 after entering, cell B1 will automatically appear the result of A2-A1, column A continues to enter, column B will be automatically displayed.

Enter at b7.

vlookup(b$15,f$17:f$999,row(a2),0)

Copy the formula down to b9 and you're good to go.

If you are in columns A to D of Sheet2, then the formula is changed to =VlookUp(B$15,Sheet2!).a$2:d$999,row(a2),0)

public function yinyong(x as range)

yinyong = worksheets("sheet2").cells(, 3)

end function

Customize a function that can be done by filling in =yinyong(b6)b5 in b5 and it will show the third column of the number in b6, and the rest will be like that, but this will not be automatically updated.

I don't really understand, it seems that you can directly implement it with = or reference functions.

Use the vlookup function to send me the file if you can't.

The formulas for those three cells are written, and the other requirements are better to be clearer.

Right-click on the label name at the bottom of the worksheet you want to enter data in, select "View" from the pop-up shortcut menu, pop up the VBA window, and paste the following ** into it.

private sub worksheet_change(byval target as range)

x =y =

if y < 3 then

y = y + 1

if y = 3 then y = 1: x = x + 1cells(x, y).select

end if

end sub

Back in the Excel window, you can enter data in columns A and B only.

Select the ab column.

Hold down Ctrl to move the cursor to cell A1.

Press the Tab key after typing cell A1.

After typing B2, press the Tab key again.