Previous in Forum: Cleaning Up a Computer   Next in Forum: Match Text in Excel
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
2 comments
Rate Comments: Nested
ronron
Power-User

Join Date: Jun 2008
Location: beverly hills
Posts: 116

Copy Sheet2 B2 to Sheet1 B2

07/21/2013 2:24 AM

Dear All

I need help in excel formula I want to copy text from sheet2 B2 if(sheet1!A1 equal to sheet2! A1 then copy sheet2B2.

Regards
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
passingtongreen
Guru

Join Date: Aug 2009
Location: Glen Mills, PA.
Posts: 2385
Good Answers: 114
#1

Re: copy sheet2 B2 to sheet1 B2

07/21/2013 9:16 AM

Use the "IF" function.

__________________
 In a time of universal deceit, telling the truth is a revolutionary act. George Orwell
Register to Reply
LongintheTooth
Guru

Join Date: Jun 2013
Location: Central Canada
Posts: 677
Good Answers: 28
#2

Re: Copy Sheet2 B2 to Sheet1 B2

08/27/2013 4:24 PM

in the target cell type =

then open the other sheet and select the cell you want to copy.

press enter and the program returns to the first sheet with the value automatically inserted.

__________________
 Smart as a post and twice as fast.
Register to Reply
Register to Reply
Have a Different Question?
2 comments

Previous in Forum: Cleaning Up a Computer   Next in Forum: Match Text in Excel

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (55 right now)
Show Members
Advertisement