Excel Data Automation: City-Based Sheets
Budget: ₹600 – ₹1,500 INR
Title:
Automate Data Filtering from Master Sheet to City-Specific Sheets in Excel Online (OneDrive)
Description:
I have an Excel workbook stored on OneDrive (Excel for the Web), which contains a central data sheet named “mock & fiesta attendance”. This sheet holds raw data from multiple centers (cities), with one of the columns (e.g., “City”) indicating which center each row belongs to.
I want to automate the process of filtering this master data into separate sheets for each city. These city-specific sheets are named in the format:
“mock & fiesta attendance (CityName)”
(e.g., “mock & fiesta attendance (Delhi)”, “mock & fiesta attendance (Mumbai)”, etc.)
Requirements:
• Build an Office Script (not VBA) that runs in Excel Online (Office 365).
• The script should:
• Read the master sheet named “mock & fiesta attendance”.
• Group rows based on the “City” column (column name may be adjusted).
• For each unique city:
• Create a new sheet named “mock & fiesta attendance (CityName)” if it doesn’t already exist.
• Overwrite any existing data in that sheet with the filtered data (including headers).
• Script should be reusable and easily editable if needed (e.g., if column names or sheet names change).
• Optional: Automatically format or clear styles from the target sheets if needed.
Deliverables:
• Working and tested Office Script integrated into my Excel file.
• Clear instructions on how to run and modify the script.
• (Optional but helpful) A brief video or screenshots showing the implementation.
This must work entirely within Excel Online (browser-based), not the desktop version, and should not rely on VBA/macros.
Automate Data Filtering from Master Sheet to City-Specific Sheets in Excel Online (OneDrive)
Description:
I have an Excel workbook stored on OneDrive (Excel for the Web), which contains a central data sheet named “mock & fiesta attendance”. This sheet holds raw data from multiple centers (cities), with one of the columns (e.g., “City”) indicating which center each row belongs to.
I want to automate the process of filtering this master data into separate sheets for each city. These city-specific sheets are named in the format:
“mock & fiesta attendance (CityName)”
(e.g., “mock & fiesta attendance (Delhi)”, “mock & fiesta attendance (Mumbai)”, etc.)
Requirements:
• Build an Office Script (not VBA) that runs in Excel Online (Office 365).
• The script should:
• Read the master sheet named “mock & fiesta attendance”.
• Group rows based on the “City” column (column name may be adjusted).
• For each unique city:
• Create a new sheet named “mock & fiesta attendance (CityName)” if it doesn’t already exist.
• Overwrite any existing data in that sheet with the filtered data (including headers).
• Script should be reusable and easily editable if needed (e.g., if column names or sheet names change).
• Optional: Automatically format or clear styles from the target sheets if needed.
Deliverables:
• Working and tested Office Script integrated into my Excel file.
• Clear instructions on how to run and modify the script.
• (Optional but helpful) A brief video or screenshots showing the implementation.
This must work entirely within Excel Online (browser-based), not the desktop version, and should not rely on VBA/macros.