clivebillowes
New Member
- Joined
- Jul 5, 2019
- Messages
- 4
Hello everyone, I am not a coding fundi, nowhere near one, every time I need Excel to do repetitive work, I record a macro, sometimes more that one to do the job. I now require Excel to do something I just can’t record. I've downloaded code but everyone I try has some or other problem, 2 days of trying and I have got nowhere.
There are 5 sheets “Quoted Client”, “PO Received”, “Progressive Invoicing”, “Completed” and “Failed Quotes”. The first 4 sheets need columns G, H & I to have drop-down list, containing “yes”, “no” & “pending”. All 5 the sheets have row 1 as the headings. There are 26 Columns across the sheets and all sheets have the same headings, the number of rows grows with time, but I have limited then to 5000.
Information per job quoted gets filled in on the first “Quoted Client” sheet, then if when we receive a PO from the client, we will add the PO info and type “yes” in column G. If the Quote fails, we type “no” into column G.
“yes” must cause the row to be moved to the next sheet “PO Received”, deleting the row on “Quoted Client” and “no” must move the row to “Failed Quotes” also deleting the row on “Quoted Client”
When the work on the PO is completed/delivered we type “yes” in column H on the “PO Received” sheet. This will move the row to “Progressive Invoicing” deleting it on “PO Received”.
In “Progressive Invoicing”, column I, we again have an option of complete invoice or progressive invoicing, here if we type “No” the row must move to “Completed”
Please if Anyone can assist
There are 5 sheets “Quoted Client”, “PO Received”, “Progressive Invoicing”, “Completed” and “Failed Quotes”. The first 4 sheets need columns G, H & I to have drop-down list, containing “yes”, “no” & “pending”. All 5 the sheets have row 1 as the headings. There are 26 Columns across the sheets and all sheets have the same headings, the number of rows grows with time, but I have limited then to 5000.
Information per job quoted gets filled in on the first “Quoted Client” sheet, then if when we receive a PO from the client, we will add the PO info and type “yes” in column G. If the Quote fails, we type “no” into column G.
“yes” must cause the row to be moved to the next sheet “PO Received”, deleting the row on “Quoted Client” and “no” must move the row to “Failed Quotes” also deleting the row on “Quoted Client”
When the work on the PO is completed/delivered we type “yes” in column H on the “PO Received” sheet. This will move the row to “Progressive Invoicing” deleting it on “PO Received”.
In “Progressive Invoicing”, column I, we again have an option of complete invoice or progressive invoicing, here if we type “No” the row must move to “Completed”
Please if Anyone can assist
Last edited by a moderator: