Search results

That's Brilliant The Rules are:- if we receive some information: M should be updated from Blank to Yes (however sometimes this is not applicable hence NA) If yes and now NA then The formula in N shows nothing If M is blank and the date of installation (P) is within 7 days then N shows Check...

I have a big tracking spreadsheet that adds new lines to the top and copy cells but collegues keep deleting a cell because it wasn't right on the previous row I have this Formula =IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"), "check with Barry", "") However in M9 there is NA which is returning check...

I have implement this =IF(AND(P6<=$B$3+7,M6<>"Yes"), "check", " ") which seems to be working, However how can I change it that if P6 is Blank then still " " ? so in N if P is empty do nothing

I need to be able to instantly know of a project is at risk by not receiving details within 7 days of install I have added an example In column N, I want it to show "check" if the install date in P is within the next 7 days (and gone past the date in P (if possible) of M does not say Yes I...

Brilliant - Thanks - works a treat

I have a spreadsheet that I track all the orders for one customer Each time we have an new order we have a macro that copies Row 6 and inserts a new row 6 and pastes it back in clearing the contens from the main section see Sub AddNewProject() This works fine, however counting up items in...

Brilliant many thanks FYI printers and tills are on a 1-2-1 relationship

I should be able to work this out but failing miserably I have provided an example and a description if v (Status is In Progress) and E is (Client owned) in x (Client owned Tills) and Y (Client owned Printers put in F(Qty) otherwise it would be zero V could be Completed, Hold, Place Holder...

Thats brilliant thanks changed so it didn't calculate for 0 or 1 only after 2. Worked out what you did so was able to change thanks for your help

quick example So if C2 = 1 then c6 is 1 if C2 >=2 <5 then C7 =1 if C2 >=5<9 then C7 =2 if C2 >=9 <12 then C7 =3 if C2 >=12 <15 then C7 =4 if C2 >=15<18 then C7 =5 if C2 >=18 <21 then C7 =6 I hope that helps

I have an order sheet that automatically calculates the labour days based on hardware installed so if I have 1 we can do in a ¼ day and therefore I have an order line for ¼ day and a formular =IF(D172=1, 1,0) if more than 1 we charge ½ day and the forular on ½ day is =IF(D172 >=2, 1,0) However...

How would I do that

https://www.dropbox.com/s/51o4ew6bsvli9zh/Customer%20Contracts%20for%20Chandoo.xlsm?dl=0 Above is a link to the file in Dropbox, its too big to upload So let me explain what I do: Each month I filter, using KUTOOLS super filter the relevant month, So now I am looking at Filtering month = 8...

I have a Workbook with 143 worksheets on it 2 worksheets are for reference ("contract Look Up" "All contracts Feb 2021" " Key" ( more of these could be added or names changed) (if it helps these have tab colours Purple from the standard row) all of the other worksheets have no tab colour at...

Good Morning Vletm, I appreciate your help. I didn't read all, for that I apologise, I jumped to conclusions that is wrong. so I can work with this and to get the new copy each week we can delete the rows already filled in and then each week starts again because the code is locked I can not...

I can't see how to run or the ability to tweak as all locked I could probably work on to clear the invoice page I realise what you asking about the master - I would normally add a macro button on the Invoice page (master) so that it will just run

I don't understand the master is missing It's all one Workbook, at the moment everyone is doing manually and emailing and I have to collate I just want it all in one place I have done something like this before but I can't find the file to reference and therefore I am stuck because I only use...

The Spreadsheet will be shared on Sharepoint or my one drive. All members can access it and even work on it at the same time. so when running the task/procedure anything in the To Invoice Tab will be removed so the procedure will collect the data from the other worksheets. We share loads of...

I might be in the wrong section, but if anyone can help it would be greatly appreciated I have a spreadsheet where each Pm will list all of the Orders they are working on To make things easier there will be one shared workbook and a tab for each PM I would like hopefully automatically, or by...

Thank you very much

I have a spreadsheet that is produced every month and I need to add up the total time per team member per type so I can show total hours spend on chargeable and foc work Example spreadsheet attached Many Thanks Sean

if I select FOC then I still get calculation which I can't have also, I don't understand how you get the d75 bit

I only need calculation on Chargeable only but need to know how its done, but also be able to get back into the pivot

I have a list of Data that I want to show in a pivot table, however half the data I would like a calculation if possible I could do in the raw data but the raw data will have 1000's of rows if, Chargeable need to show as calculation of £75 per hour

perfect, Thanks, works a treat