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...
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
looks filter is ok to separate one sheet to sheet_complete.and sheet_in_process according to column R.
3,4,7,9 (representing four individual jobs) in yellow
R8=complete?
not yellow?
looks filter is ok to separate one sheet to sheet_complete.and sheet_in_process according to column R.
3,4,7,9 (representing four individual jobs) in yellow
R8=complete?
not yellow?
R8 should be yellow.
Sorry, I was in a bit of a rush.
I've been thinking since I sent files.
I am looking to activate the move from 'Live Works' to 'Completed Works' when the date and time is entered in column 'AC'.
Would changing the date & time format to "DD/MM/YY HH:MM" in column 'AC' make this possible?
Once again thanks in advance.
Sorry, I was in a bit of a rush.
I've been thinking since I sent files.
I am looking to activate the move from 'Live Works' to 'Completed Works' when the date and time is entered in column 'AC'.
Would changing the date & time format to "DD/MM/YY HH:MM" in column 'AC' make this possible?
Once again thanks in advance.
Your column AC is text rather than datetime number,causing you can not just format them as time format which you expected.
Why do you need change the format?
Do you need further calculation based on this column？
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.