•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Type script move rows
Our take
If you're working with Excel Office Scripts using TypeScript and need to filter and copy data between worksheets, you're in the right place. Your goal is to automatically transfer rows where the "COMPLETE" column equals 100% from the original sheet, starting from row 10, to a destination sheet while removing those rows from the original. If your code isn't functioning as expected, let's explore the common pitfalls and refine your approach to ensure a seamless data management experience.
I am trying to create an Excel Office Script (TypeScript) to filter and copy data between worksheets.
Data starts around row 10
One of the columns is named "COMPLETE"
This column contains percentage values (e.g. 30%, 60%, 90%, 100%)
I want to automatically copy only the rows where the COMPLETE column is 100% into the destination sheet and eliminate them from the original sheet, idk why my code isnt working
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#row zero#no-code spreadsheet solutions#TypeScript#Excel#Office Script#COMPLETE