auto fill data from another worksheet

[nhojyer00]

hi guys, may i ask some help?

i want to autofill the data from worksheet 1 to worksheet 2.

for example;
in worksheet 1
cell a1=1234
cell a2=1235
how can i make it in worksheet 2 to fill automatically the contains in cell a1 and cell a2.

or let us say when i type 1234 in cell a1 in worksheet 1 it will also automatically fill the cell a1 in worksheet 2 as 1234 and
when i type 1235 in cell a2 in worksheet 1 it will also automatically fill the cell a2 in worksheet 2 as 1235 and so on and so fort.

thank you for the help guyz

[FDibbins]

Hi and welcome to the forum

in sheet2 enter =sheet1!A1
copy down

[nhojyer00]

thank you sir for helping me,

but what about if on separate workbook
can i also do that?

[FDibbins]

Thanks for the feedback

Sure you can do it to another workbook...

=[Book5]Sheet1!$A$1

The easiest way to do it, is to just use your mouse. 1st press = then use your mouse to point to the cell you want, doesnt matter if its onthe same sheet, a different sheet, or even a different workbook (file), just click on te cell you want to reference, then press enter

Hope that helps?

[nhojyer00]

but when i copied it and drag the copied cell down, it just copied the same formula.

let us say;
in cell a1 it appears " =[workbook1]Sheet1!$A$1" , then i copied cell a1 to a2,a3 and so on and so fort but it will just copy the same formula. How to make it automatically change the formula like;
in cell a2 it will be automatically copy the contains in cell a2 of workbook 1
in cell a3 it will be automatically copy the contains in cell a3 of workbook 1 and so on and so forth.

thank you for responding sir.

[FDibbins]

ooops sorry, my bad...remove the $

=[Book5]Sheet1!A1

[nhojyer00]

thank you very much sir....it really works....

[FDibbins]

Happy to help