Read records up to a unique value in a column

MRoyW

Hi, I have multiple worksheets that I want to combine using a batch macro. However, each has a different number of rows (line items) that I would like to be selected up to the total cost of goods. For example, shown in the table: (Actual data has numerous columns for monthly actuals, budget and forecasts)

How can I select records using such a criteria?
Thanks

Item	Value
Revenue
tg	4
ju	13
Total revenue	17
COGS
tg	3
ju	11
Total COGS	14

OllieClarke

Hey @MRoyW in your batch macro, have something like the below which finds the recordID of the 'Total COGS' row, appends that recordID onto all records, and then only keeps the records before that RecordID.

Hope that helps,

Ollie

COGS.yxmd