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 |
Solved! Go to Solution.
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
@MRoyW
Is this what you want?
@OllieClarke
Ours are surprisingly similar!😁
My formula tool seems to be reduntant.
Thanks, that works perfectly.
Yes, I had a look at both and they're similar. Thanks guys 😄
@MRoyW
Maybe you can also mark mine?😁
@MRoyW
Thank you very much. I am trying to get 50 accepted. hhaa