Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

**patrickrw99** · 03-01-2022, 12:29 AM

Hi,
I have a question regarding Office Scripts in Excel Online, on how to conditionally copy data from one Sheet (Lets just Say Sheet A) to another sheet (Sheet B), if the value meets certain criteria in SheetB. For example:
Sheet A Columns : Name (name of the person) , Age (age of the person) , Fail/Pass (value will be either fail or pass)
Sheet B Columns: Name (name of person), Subject (Subject taken), score (value of the score of the subject)
I would like copy the name values from Sheet B to Sheet A, if the name already exists in Sheet A AND the Fail/Pass value in sheet A for the person is also Pass. Please do note that the name on sheet B can appear more than once and I would like to copy all of the values (Therefore for example if a person named "James" match the criteria from Sheet A, and "James" appeared in Sheet B 3 times, I want to copy all 3 instances of "James" as well as the subject and Score values from Sheet B to Sheet A

Any solutions is welcome (including formulas) or using Office Scripts, however, it must be implemented in excel online and therefore VBA/macros cannot be used.

EDIT: I've added a sample file with Sheet A, Sheet B and expected result that will be shown in Sheet A.

Thank you!

**jindon** · 03-01-2022, 02:19 AM

Output in F1,

Please Login or Register  to view this content.

**patrickrw99** · 03-01-2022, 03:02 AM

Originally Posted by jindon

Output in F1,

Please Login or Register  to view this content.

Hi unfortunately as the original post stated, I cannot use macro or VBA, and must use office script/any type of excel formula as i am using excel online. Therefore any solution using office script is very much appreciated

**jindon** · 03-01-2022, 03:04 AM

Ahhh, I missed it...

**patrickrw99** · 03-01-2022, 03:08 AM

Originally Posted by jindon

Ahhh, I missed it...

No worries, thank you for trying to help, if you know the solution using Office Scripts/any regular formulas, please let me know thank you!

**AliGW** · 03-01-2022, 03:26 AM

Thread has been moved to the Formulas & Functions section - don't post in the VBA section if you can't accept a VBA solution!!!

**patrickrw99** · 03-01-2022, 03:49 AM

Hi I'm sorry that I put this thread in the VBA Section, but as I recall Office Scripts is a part of Excel programming, and I explicitly stated that I was also open to any solutions using office Scripts. Therefore I don't see a problem with me putting this thread in the Excel Programming Section, and please do note as well that I've also stated that Formulas and functions are only one of the solutions that I am also open to, I never stated the solution must be in the form of formula.

**AliGW** · 03-01-2022, 03:51 AM

However, you also stated in your duplicate thread that you felt the thread would be better placed in this section (Formulas & Functions), and I have decided that this is correct. If you want to flag Office Scripts, then add this to the title of the opening post.

You are, of course, completely missing the point: duplicate threads are not allowed.

**jindon** · 03-01-2022, 03:57 AM

Originally Posted by patrickrw99

Hi unfortunately as the original post stated, I cannot use macro or VBA, and must use office script/any type of excel formula as i am using excel online. Therefore any solution using office script is very much appreciated

Don't know if this works(tested and working here)

A6:
=LET(x,FILTER($A$2:$A$4,$B$2:$B$4="Pass"),FILTER(SheetB!A$2:A$6,ISNUMBER(MATCH(SheetB!$A$2:$A$6,x,0))))
Copy to then right.

**patrickrw99** · 03-01-2022, 04:51 AM

WOW! Thank you very much for the help. The formula worked and you've been very helpful! Once again, thank you!

Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Re: Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A

Thread Information

Users Browsing this Thread

Similar Threads

Log Cell Changes of Existing Data in Sheet 1 and Copy Entire Row in Sheet 2

Copy data from one sheet to another sheet multiple times based on criteria from one sheet

Copy specific range from the new existing Active Sheet and paste value to Master sheet.

Copy Data From Master Sheet into Separate Sheet Based on Value found in Master Sheet

[SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1

[SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A

[SOLVED] [SOLVED] Copy the entire sheet to overlay existing sheet?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions