How can I copy cells from another sheet with multiple instances of the Matched cell reference

RCruz

I'm new to the community, hello!

Scenario: I have a source sheet with time entries for all resources and all projects. Project ID appears in all rows.

I want to copy rows with the same Project ID’s into individual sheets, by sheet reference.

I am familiar with “Index/Match”, but I do not know how to capture multiple instances, can anyone help?

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @RCruz,

Could you provide a sample of the data/sheets you're trying to Index/Match? This can help us better understand the information you're trying to gather. Please be sure to hide any sensitive information when providing the screenshot.

Thanks!

RCruz

"Project ID 1" is used to match the records. My intent is to copy the Row and sum the hours for each User, in the destination sheet.

Source_Data__Time_Entries_report.xlsx

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.