hi to all
Is their a way so that if a row is inserted in (task/sheet), then all formula's for (row2- data/sheet) appear in the previous inserted row
- notice that the row has cells from A to T
data sheet.png
Task sheet.png
hi to all
Is their a way so that if a row is inserted in (task/sheet), then all formula's for (row2- data/sheet) appear in the previous inserted row
- notice that the row has cells from A to T
data sheet.png
Task sheet.png
Last edited by azar3; 08-11-2020 at 01:14 AM.
Make the range a Structured Table.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks and i have add to my queation A "table photo"
It may help someone to propose a solution if we could see the actual .xlsx file.
Instructions are given in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
its google sheet i need a script editor, and its unable from the site to make a link
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks