Forum Discussion
EXCEL HELP
Hi guys, First-ever question to the tech team. I work in a small body repair shop that deals principally with a vehicle rental company and looking to cut back on paper use by putting the works proc...
My apologies for the delay in reply and for being a nuisance.
The worksheet has been revised, please find attached, Live and Completed Works (MS team).
- Extra Columns, the last column is now ‘AD’
- Yellow highlighted rows in ‘Live Works’ are complete.
- These (yellow highlighted) rows I’m looking to be automatically transferred to ‘Completed Works’ with ‘white/no fill rows’ 7 & 13 left in ‘Live Works’, with both rows being moved to the top of the file (Live Works).
- The auto transfer function will happen when the relevant cell in column ‘AD’ (Live Works) is populated with the ‘Handover Date/Time’. This action completes the job.
- With regards to your last post, I’d merely been reading that this date/time (column AD) may have to be displayed in “dd/mm/yyyy” format. I apologise for misleading you.
- As I’d mentioned in my initial request, I’m limited in terms of the functions available in Excel.
- If by merely populating cell ‘AD’ activates the file transfer, (that is no need for a formatted date/time) this is what I would be looking for.
Once again, thanks in advance for your time and patience
convert live works to Table,them apply.filter on sheet completed works.
=FILTER(表1,表1[HANDOVER DATE/TIME]<>"")
In this case,using sql.to filter also an option.
See attached in detail.