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.