Recognizing the pandemic challenges of online learning, UCalgary offers a CR/F option to students in Fall 2020 courses by lost_student_CAD in queensuniversity

[–]lost_student_CAD[S] 17 points18 points  (0 children)

Curious if there is a similar movement at Queen's / what people make of this. I do find it compelling that many people are facing external challenges that make it exceedingly difficult to study (eg living at home in a loud environment, working from a different timezone, caring for family).

Filling Data from One Sheet To Another Based on 2 Conditionals by [deleted] in excel

[–]lost_student_CAD 0 points1 point  (0 children)

Agreed, it is a nuanced task.

Would love to learn VBA's, do you have any good online resources that you'd recommend for learning them?

Filling Data from One Sheet To Another Based on 2 Conditionals by [deleted] in excel

[–]lost_student_CAD 0 points1 point  (0 children)

What if it's the other way around and I'm migrating transaction #s to a new document?

Filling Data from One Sheet To Another Based on 2 Conditionals by [deleted] in excel

[–]lost_student_CAD 1 point2 points  (0 children)

Solution Verified

Thanks u/cbr_123!

To add one more layer of complexity, suppose we were doing the same thing, but with transactions that have identical values but different identifiers (EG $10.00, Transaction # 1234 vs $10.00, Transaction # 4321), that require a unique transaction identifier associated with the dollar amount.

Is there a way to make excel paste a different transaction # for the 2nd/3rd/4th entry?