Copy Cell in Sheet2 if text = true

**GOrtega** · 04-02-2020, 04:04 AM

Shee1
A1
New Referral

B1
11111

C1
Yes

D1
00/00/2020
----------------------------------------------------------------
Sheet2

A1
11111
B1
Yes
D1
00/00/2020

If A1 = New Referral, Copy B1,C1,D1 to Sheet2

can someone help me with this kind of formula?

**alansidman** · 04-02-2020, 07:17 AM

A VBA solution

Please Login or Register  to view this content.

**GOrtega** · 04-02-2020, 11:18 PM

Thank you let me test it.

**GOrtega** · 04-03-2020, 12:04 AM

What if
Column B = New Referral

copy entire row to sheet 2

**alansidman** · 04-03-2020, 05:23 AM

Please Login or Register  to view this content.

**GOrtega** · 04-03-2020, 06:48 AM

thank you for your fast response sir, but i can't seems to made it run or work. maybe because im newbie on vba, anyway thank you for your effort on responding. hope you can teach me how to make this work.
this is my worksheet i want to copy the rows with "New Referral" Sheet1 to Patient Information. Sheet3.
attached image is my excel, i can't upload the excel itself

Attachment 670473

**6StringJazzer** · 04-03-2020, 08:23 AM

Originally Posted by GOrtega

attached image is my excel, i can't upload the excel itself

See the yellow banner at the top of the page for instructions to attach the Excel file. If it is over 1MB you may zip it and attach a ZIP file up to 9.77MB.

**alansidman** · 04-03-2020, 10:39 AM

Your attachment is not visible. See 6's post #7

**GOrtega** · 04-07-2020, 06:02 PM

Hi guys i already attached my files thank you.

**GOrtega** · 04-07-2020, 06:06 PM

is there a possibility if already input auto fill the bday, gender and nationality

**alansidman** · 04-07-2020, 07:29 PM

Please Login or Register  to view this content.

How to install your new code

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button

**GOrtega** · 04-07-2020, 07:36 PM

Work Great thank you so much..

**alansidman** · 04-07-2020, 07:44 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Copy Cell in Sheet2 if text = true

LinkBack

Thread Tools

Rate This Thread

Display

Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Re: Copy Cell in Sheet2 if text = true

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy text from one cell in sheet1 to sheet2

[SOLVED] Find text in column A then copy the cell to the right and paste it in sheet2

[SOLVED] If cell value on Sheet1 not found on Sheet2 copy row to Sheet2

Find the specific text and copy and paste in another cell only if true.

[SOLVED] Search range and copy cells to sheet2 if, if statement is true

Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2

How to copy a range of columns from sheet1 to sheet2 if the cell show a specific text

Bookmarks

Bookmarks

Posting Permissions