◆ Excel · automate

Automate Data Formatting

Write a short macro that standardises incoming supplier files into our template by reordering columns, fixing date for…

2heights
2tasks
1roles do it
See the prompt↓More automate workflows

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Write a short macro that standardises incoming supplier files into our template by reordering…+
Write a short macro that standardises incoming supplier files into our template by reordering columns, fixing date formats and trimming spaces so I don't reformat before uploads.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Provide a reusable macro for the stock clerk: import supplier files, map common column names to…+
Provide a reusable macro for the stock clerk: import supplier files, map common column names to our template, normalise dates and numbers, collapse empty rows, and produce a quick QA report listing rows requiring manual review before upload.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Write a short macro that standardizes incoming supplier files into our template so I don't have to reformat before every upload.

Who does this

1 roles
Store Supervisor

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.