Excel Tab Duplication & Data Entry
Budget: $30 – $250 USD
I have an existing sales workbook in Excel where each product lives on its own tab. I now need 4–6 brand-new tabs that look and behave exactly like the current ones—same layout, formulas, conditional formatting, and every drop-down or other data-validation rule intact.
Once those tabs are in place, I’ll pass over a batch of raw figures. Your job is to place the product-quantity numbers and corresponding customer information into the correct columns on each new sheet, making sure every formula continues to calculate as intended. Accuracy is critical because these sheets feed our live dashboards, and I’d like the updated file back within 24 hours of project start.
Deliverables:
• Clone 4–6 tabs so they are identical to the existing templates
• Replicate all data-validation settings from the original tabs
• Enter provided product-quantity and customer-detail rows into the proper columns
• Verify that totals, lookups, and references work flawlessly after entry
I’ll be available for quick clarifications, and a smooth first run will open the door to regular follow-up work.
Once those tabs are in place, I’ll pass over a batch of raw figures. Your job is to place the product-quantity numbers and corresponding customer information into the correct columns on each new sheet, making sure every formula continues to calculate as intended. Accuracy is critical because these sheets feed our live dashboards, and I’d like the updated file back within 24 hours of project start.
Deliverables:
• Clone 4–6 tabs so they are identical to the existing templates
• Replicate all data-validation settings from the original tabs
• Enter provided product-quantity and customer-detail rows into the proper columns
• Verify that totals, lookups, and references work flawlessly after entry
I’ll be available for quick clarifications, and a smooth first run will open the door to regular follow-up work.