Hi All, I have one query. There will be specific pattern in sheet1 like {Year\Month} or {yy_mm_dd} in column A.when it will encounter similar patterns it has to move to Sheet3 where values will be assigned to corresponding pattern. I need to process records row by row. Will anyone suggest which is the best approach to implement this. Please find the attachment for reference.
Related Topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Automate Read-Write Excel sheet and apply calculations | 0 | 100 | February 6, 2024 | |
How can I process all the "Name of results Save" column's rows for a date variable (like yest date) using Excel query? | 10 | 791 | May 7, 2022 | |
Regular expression for some pattern in excel | 6 | 572 | August 1, 2022 | |
Excel Automation :Comparing dates in excel with current date and if matched fetching the associated job name in other column | 12 | 2345 | October 29, 2018 | |
Excel filtering and sequential numbering | 1 | 229 | July 31, 2023 |