Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

I use google sheets a lot for my business. I was wondering…

Customer Question
I use google sheets a...
I use google sheets a lot for my business. I was wondering if there is a way to link one row with another row in a separate google sheet OR one row with the same google sheet in another tab.For example I make changes on one row and the changes automatically happen to the row linked in another tab or another google sheet.
Submitted: 7 months ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 29 minutes by:
11/28/2017
Tech Support Specialist: The-PC-Guy, Computer Manager replied 7 months ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2,206
Experience: 20 years experience providing remote computer support
Verified

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

Ask Your Own Computer Question
Tech Support Specialist: The-PC-Guy, Computer Manager replied 7 months ago

you would have to do this one cell at at time

for example

in sheet1 A1 put

=sheet2!A25

this will tell you to use the value from sheet2 the 25th row.

then you can copy and paste that formula for as many columns as you need

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE STARS AT THE TOP OF YOUR SCREEN

Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

*** REMEMBER TO APPLY BONUS, THIS IS VERY MUCH APPRECIATED AS IT IS HOW I MAKE A LIVING ***

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

http://www.justanswer.com/computer/expert-1expert-2rulethemall/s

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.

Ask Your Own Computer Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2,206
2,206 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,252 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
Can I enable conditional formatting in Google Sheets so that
Can I enable conditional formatting in Google Sheets so that the color of a cell changes if and only if the CONTENT CHANGES in that cell. Is that possible? … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,206 satisfied customers
Is it possible to view Google Spreadsheet Row data one at a
Is it possible to view Google Spreadsheet Row data one at a time, like in a form? I have to check the data in a google docs spreadsheet row by row, and it would be nice if I could check it with just t… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Excel 2003. Vista. I have a spreadsheet containing cell references
Excel 2003. Vista. I have a spreadsheet containing cell references which 'import' text from a separate tab. Row Autoheight works on the text itself but not on cells containing a formula which 'imports… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Is it possible to have an auto addition from one cell to another after input ,, for exampl
Is it possible to have an auto addition from one cell to another after input ,, for example a date as month/year eg 08/10 in the first cell to auto sum by 4 year in a designated cell eg 08/14 ?… read more
Jess M.
Jess M.
Bachelor\u0027s Degree
3,558 satisfied customers
Does MS Word have a search feature that will find non-consecutive
Does MS Word have a search feature that will find non-consecutive duplicate words in a document? I have a Word document containing hundreds of email addresses. I know there are some duplications as a … read more
Frederick S.
Frederick S.
Computer Specialist
High School or GED
7,241 satisfied customers
How do I enter a zip code into excel that starts with a 0
How do I enter a zip code into excel that starts with a 0? I currently have one column with street,city and zip codes. I need them all separate. Can i do this without re typing the zipcodes? I have ab… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
I want to create a set of linked Excel spreadsheets within
I want to create a set of linked Excel spreadsheets within a Workbook in which the first few columns of names and affiliations are the same in each spreadsheet. Can you show me how to link the names e… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
I am currently linking cells in sheets named Candidate 1 ,
I am currently linking cells in sheets named "Candidate 1", "Candidate 2" etc into a sheet named "Consolidated" in the same workbook. I have 30 candidates that i need to link to the "Consolidated" she… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
I have excel 2003 and I want to write a formula for this scenario.
I have excel 2003 and I want to write a formula for this scenario. I have 20 rows of data with one of the cell options being a priority drop down. I want a separate sheet to pull all of the #1 priorit… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Working in excel. I want to automatically create additional
Working in excel. I want to automatically create additional worksheets that are specific to info from individual columns. My rows are people. My columns are jobs. Some people have more than one job ,s… read more
Adam C
Adam C
Systems Administrator
Diplom
15 satisfied customers
I have a workbook with numerous tabs containing budget data
I have a workbook with numerous tabs containing budget data from different lob areas...each with a different amount of rows. I want to copy data from each to a summary sheet appending automatically. I… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Heres my dilema I work for a medical clinic and do physician
Here's my dilema: I work for a medical clinic and do physician payroll. They are technically considered self employed and pay both the employee and employer portion of taxes. I am responsible for calc… read more
Dave G
Dave G
ONC
48 satisfied customers
Hi Using Excel I am trying to populate a table one row at
Hi Using Excel I am trying to populate a table one row at a time from a series of back sheets. I would like it so that each time a back sheet is filled in the front sheet recognises it, then moves dow… read more
Danny B
Danny B
Associate Degree
62 satisfied customers
Is there an easy way to run headers and footers (inc Fonts)
Is there an easy way to run headers and footers (inc Fonts) across sheets in an Excel 2002 workbook without typing it into each sheet?… read more
Karl Everest King
Karl Everest King
Web Designer, Programmer
Vocational, Technical or Trade Scho
224 satisfied customers
in a table, when I add columns, excel automatically labels
in a table, when I add columns, excel automatically labels the column and will not repeat a column name. for example, if a column is labled %, it will add a column named %1. is there a way to turn thi… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
I have a mailing list but the name address and city state ...
I have a mailing list but the name address and city state and zip are all in column A and have a space in between each person. Name address city state, zip then space Name Address city state, Zip Is t… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
I have set up an excel spreadsheet as a data base - names ...
I have set up an excel spreadsheet as a data base - names addresses etc. Within that database there are several groups that I have copied into separate worksheets - so I now have a Master sheet and 5 … read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Is there a way to transpose cells from one sheet to ...
Is there a way to transpose cells from one sheet to another and keep the links intact so that the cells still refer back to the correct cell on the first tab. Example. I have columns that calculate pe… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x