**Question description:**

*This user has given permission to use the problem statement for this blog.*

i need to have whatever data i input in excelsheet file #1 column A
automatically transfer to another worksheet/ another file#2 column B

Solved by I. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/08/2017 - 11:02

Hi, It's pleasure to help you today :)

Excelchat Expert
20/08/2017 - 11:02

Explanation phase:

User
20/08/2017 - 11:02

hello robot

Excelchat Expert
20/08/2017 - 11:02

I am not robot

User
20/08/2017 - 11:02

Hi Felicia

Excelchat Expert
20/08/2017 - 11:02

I am an excel expert working for Got it Pro

User
20/08/2017 - 11:03

okay export, shoot

User
20/08/2017 - 11:03

here's what i need

Excelchat Expert
20/08/2017 - 11:03

Please provide me an example an example

Excelchat Expert
20/08/2017 - 11:03

Ok. Great.

User
20/08/2017 - 11:03

ill put up an simple analogy

Excelchat Expert
20/08/2017 - 11:03

Sure

Excelchat Expert
20/08/2017 - 11:04

Please use preview sheet to add the details.

User
20/08/2017 - 11:04

can you see the preview?

Excelchat Expert
20/08/2017 - 11:05

Yes. I can see it

User
20/08/2017 - 11:06

KINDLY TOGGLE BETWEEN SHEET #1 & SHEET #2

Excelchat Expert
20/08/2017 - 11:07

Ok. From sheet 1 to sheet 2. It is possible to transfer the data from this file.

Excelchat Expert
20/08/2017 - 11:07

using formulas

Excelchat Expert
20/08/2017 - 11:07

I am going to show one example.

User
20/08/2017 - 11:07

please note

User
20/08/2017 - 11:07

its a different file sheet

User
20/08/2017 - 11:07

this should be simple,

User
20/08/2017 - 11:07

but for years

Excelchat Expert
20/08/2017 - 11:07

If it is a different file, then we have to add the path before the formula

User
20/08/2017 - 11:07

i can't find an answer

User
20/08/2017 - 11:08

okay lets start with

User
20/08/2017 - 11:08

two different worksheets

Excelchat Expert
20/08/2017 - 11:08

Ok. I will provide with a simple example and notes

User
20/08/2017 - 11:08

worksheet 1 transfer to worksheet 2

Excelchat Expert
20/08/2017 - 11:08

Please follow the steps

Excelchat Expert
20/08/2017 - 11:08

Ok. Sure. I will do it now for the sheets

Excelchat Expert
20/08/2017 - 11:08

I will delete the existing text

Excelchat Expert
20/08/2017 - 11:09

Is it always start from row 4?

User
20/08/2017 - 11:09

any rows

User
20/08/2017 - 11:09

any columns

Excelchat Expert
20/08/2017 - 11:09

ok. Please take look at it.

User
20/08/2017 - 11:09

just make it magically transfer

Excelchat Expert
20/08/2017 - 11:09

Any row, any column?

Excelchat Expert
20/08/2017 - 11:09

Sheet 1 A column to Sheet 2 column C?

User
20/08/2017 - 11:10

okay

User
20/08/2017 - 11:10

go

Excelchat Expert
20/08/2017 - 11:10

Ok .Please type in sheet 1 column A

Excelchat Expert
20/08/2017 - 11:10

and check in sheet 2

Excelchat Expert
20/08/2017 - 11:11

Please use proper language

Excelchat Expert
20/08/2017 - 11:12

We are here to help you with your requirements and we expect co-operation as well. Thanks. Hope you will understand.

User
20/08/2017 - 11:12

how to do this

Excelchat Expert
20/08/2017 - 11:12

Ok. Please take look in sheet2

Excelchat Expert
20/08/2017 - 11:12

=Sheet1!A1

User
20/08/2017 - 11:12

you are using the "=" formula

Excelchat Expert
20/08/2017 - 11:13

I have linked the sheet2 c1 with Sheet1 A1

User
20/08/2017 - 11:13

how did you do it?

Excelchat Expert
20/08/2017 - 11:13

In C1 type

Excelchat Expert
20/08/2017 - 11:13

=Sheet1!A1

Excelchat Expert
20/08/2017 - 11:14

Now, you just copy and paste it on other cell in sheet 2

Excelchat Expert
20/08/2017 - 11:14

It is not B:B

Excelchat Expert
20/08/2017 - 11:14

It is just B1

Excelchat Expert
20/08/2017 - 11:14

=Sheet1!B1

User
20/08/2017 - 11:15

how to do it

Excelchat Expert
20/08/2017 - 11:15

You made it finally :)

User
20/08/2017 - 11:15

im just

User
20/08/2017 - 11:15

no i didnt

User
20/08/2017 - 11:15

its just 1 cell

User
20/08/2017 - 11:15

i want the whole column like you did

Excelchat Expert
20/08/2017 - 11:15

You can copy and paste for all the cells

Excelchat Expert
20/08/2017 - 11:16

copy it and select column E and paste it

Excelchat Expert
20/08/2017 - 11:16

for copy ctrl+C

Excelchat Expert
20/08/2017 - 11:16

paste: ctr+v

User
20/08/2017 - 11:16

OHHHHHHH

Excelchat Expert
20/08/2017 - 11:16

Yes. You got it.

User
20/08/2017 - 11:16

how about another file?

User
20/08/2017 - 11:16

the same?

Excelchat Expert
20/08/2017 - 11:16

You have add the path before sheet1

User
20/08/2017 - 11:17

i think that will automatically appear right?

User
20/08/2017 - 11:17

the path

Excelchat Expert
20/08/2017 - 11:17

Here we can't create a seperate file. We deal with single file

Excelchat Expert
20/08/2017 - 11:17

Yes

User
20/08/2017 - 11:17

if i click on the dependent cell from another file

Excelchat Expert
20/08/2017 - 11:17

Yes.

User
20/08/2017 - 11:17

okay

User
20/08/2017 - 11:17

thanks

User
20/08/2017 - 11:17

next question

Excelchat Expert
20/08/2017 - 11:17

Open the files

User
20/08/2017 - 11:17

if i need more help

Excelchat Expert
20/08/2017 - 11:17

and select one cell to another file

User
20/08/2017 - 11:17

how can i access this website

User
20/08/2017 - 11:17

like how do i pay

User
20/08/2017 - 11:17

do you accept paypal?

User
20/08/2017 - 11:18

and how much

Excelchat Expert
20/08/2017 - 11:18

Please use EX_CH for new queries. As per the policies, we will answer one question at a time per session.

Excelchat Expert
20/08/2017 - 11:18

I will provide you the details of the package.

User
20/08/2017 - 11:18

im not asking another question about excel

User
20/08/2017 - 11:18

im asking payment options

Excelchat Expert
20/08/2017 - 11:18

EX_CH is my expert code, you can provide in the description along with the requirement

User
20/08/2017 - 11:18

oh okay

User
20/08/2017 - 11:18

thanks

Excelchat Expert
20/08/2017 - 11:18

users must pay by purchasing credits. Pay model is as follows: 1 session (16 credits) for $3.99 3 sessions (48 credits) for $9.99 15 sessions (240 credits) for $44.99

User
20/08/2017 - 11:18

where

User
20/08/2017 - 11:19

can u give link for payment options

Excelchat Expert
20/08/2017 - 11:19

Here are payment options.

Excelchat Expert
20/08/2017 - 11:19

When you register, you will be asked to opt for any of these options.

Excelchat Expert
20/08/2017 - 11:19

Please take look at the above options

User
20/08/2017 - 11:19

do you have paypal?

User
20/08/2017 - 11:19

please bloody have paypal please

Excelchat Expert
20/08/2017 - 11:19

Hope, i have resolved all the queries. We don't have such facilities of paypal.

User
20/08/2017 - 11:20

oh sh***

User
20/08/2017 - 11:20

my goodness! its 2017

Excelchat Expert
20/08/2017 - 11:20

You can pay it through any of the modes to purchase credits

User
20/08/2017 - 11:20

can i pay cash?

User
20/08/2017 - 11:20

which modes? can i have a link

Excelchat Expert
20/08/2017 - 11:21

Please visit Got it Pro and subscribe for it. You will see all the options.

Excelchat Expert
20/08/2017 - 11:21

If you need further help on this

Excelchat Expert
20/08/2017 - 11:21

I will provide an email

Excelchat Expert
20/08/2017 - 11:21

sheets.support@gotitapp.co

Excelchat Expert
20/08/2017 - 11:21

Please send mail to this

Excelchat Expert
20/08/2017 - 11:21

Please approach Got it Pro for new queries. Click on Red cross next to timer to end the session and leave a great rating.

Excelchat Expert
20/08/2017 - 11:21

Have a great day:)

User
20/08/2017 - 11:21

i can't see the pricing options on your website and payment options

Excelchat Expert
20/08/2017 - 11:21

When you register, they will appear for sure

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*