Duplicate sheets within workbook — AI Prompts for Google Sheets

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

I need to duplicate the Marketing sheet within this workbook, keep all formulas relative to the new…

I need to duplicate the Marketing sheet within this workbook, keep all formulas relative to the new sheet, and rename the copy to Q3-Marketing before I hand it to the regional lead tomorrow morning.

Improve — make it easier to accept

Before I duplicate the Marketing sheet for the regional lead, make the copy easy to validate:…

Before I duplicate the Marketing sheet for the regional lead, make the copy easy to validate: update any sheet-level references that still point back to the original, add a footer showing the source sheet name, and highlight formulas that depend on other tabs so the reviewer knows where to look.

Decide — diagnose the stuck moment

I copied the Marketing tab and now summary totals on the new sheet point back to the original,…

I just duplicated a sheet and totals broke

I copied the Marketing tab and now summary totals on the new sheet point back to the original, giving wrong numbers. Alex in regional ops will rely on the copy. I don’t know whether the broken links are from named ranges or sheet-scoped references. What’s the fastest way to fix the references so the duplicate is self-contained and I can tell Alex what changed?

Become — change the pattern

Each quarter I duplicate templates and later discover some copies still pull from the master, which…

I keep creating copies that silently link to originals

Each quarter I duplicate templates and later discover some copies still pull from the master, which causes embarrassing errors in regional reports. It eats my credibility and time. What habit or small checklist will stop unintended cross-sheet links and make copies reliable every time?

Next to this one

Other spreadsheet work people do in Google Sheets.

Create and assign tasks from sheet Create and manage named ranges Create custom functions with Apps Script Create dropdown data validation Create templates for reuse Enter raw data rows Export sheet as CSV or PDF Filter rows by criteria Format cells and ranges Freeze header rows or columns

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt