Search results

Team please support..... I am badly stuck in it

Hi, I want to transpose Excel data which size is irregular, but a portion of the string ("test_dns") is common at the starting of each data range. I want the macro to be paste values containing "test_dns" (this is just a portion of the string, which can be anywhere in the string) row by row and...

Stephan Your question is not understandable. what do you mean by "TAB YEAR: 2020"? Also, I don't understand the term "Tab TOTAL".... Do you mean Worksheet "TOTAL" or anything other?

You are welcome. By the way, I don't understand your question about worksheet and button. You can add any shape as per your wish and after assign macro by right click on it you can use the shape as a button. Please refer the file I shared above. You can also get VBA code of hide and unhide of a...

vletm There should be some technical issue..... My full reply is like this..... Here, I am attaching the same file for you......

vletm Let me answer your questions. A) "if someone wanted to use unused hours" - then he should share the logic of calculation also. Sharing the logic of used hour and calculate using unused hour is not crazy? B) "Employee Type ... was it in original form ... does someone mention it?"-- You are...

zeeworld Please check this... A little modification of the file shared by @vletm. vletm the payroll admin calculates the payment based on the used hour, not on the available hour and from the very first zeeworld trying to calculate based on unused hours. In the above calculation process 120...

vletm, I think there is an error in the calculation of Total hours in C4, as you are only considering for Non-exempt employees (G4:G7) and overlooking Exempt employees (H4:H7). In the given example Jhon Doe is an exempt employee. I also have one doubt about the pay period (C5). your logic is...

Vijayarc Your given logic and example do not match. Your logic is Then for the below caseid comment should be Good to offboard instead of WIP- Partial completed. CASID Client ID Combination CDGL Lookup CaseID Duplicate Comments 222454699 9370068221 2224546999370068221 NA Duplicate WIP-...

edbarton I think you want something like this....... If any password needed, the password will be "123".

hollys2042 Please try the below code in H7 and copied down. =IF(DATEDIF(E7,F7,"y")>=20,25,IF(DATEDIF(E7,F7,"y")>=15,20,IF(DATEDIF(E7,F7,"y")>=10,17,IF(DATEDIF(E7,F7,"y")>=5,15,IF(DATEDIF(E7,F7,"y")>=1,10)))))&" Days" Note:: for <1 year no logic is there, so for this the result will be "False...

Thanks bosco_yip. I missed this point. You are awesome as always. But still, there is a drawback in my formula as well as your formula. Both formulas working without checking the employee name, just referring to the cell. How could this drawback be overcome?

vinoth.s1 Please find this is working or not.

k_rahul_g Please share the sample file.

belinea2010, please check the below line of VBA Code. Activecell.Formula="=SUBSTITUTE(IF(ISNUMBER(SEARCH(""wav"",Data_Import!A1)),MID(Data_Import!A1,SEARCH(""kHz"",Data_Import!A1)+4...

Hi, please share the sample file.

@sabari161, I don't have any idea about "Quarterly Prepaid allocation". Please explain the logic of calculation.

Please share the sample file.

Be3ee, Please share more details like Web page link sample excel file if any etc. Also, elaborate on your problem. Only a question is not helpful, we need some information as well.

sabari161, I think you should share the correct result by doing the manual calculation along with the formula you made. Because without the correct result it is very much difficult to answer whether the formula is correct or not. Or you can share the calculation logics as well.

Alina, please check whether my sheet is working as per your need or not. Here, instead of making month by month sheets, you have to maintain two sheets only one is for Previous months and another is for Current month. Note: "Month" Column should be sorted as Oldest to Newest for the Previous sheet.

Thank you for your advice bosco. I will keep it in mind from next time.

Yes, but belinea already mentioned that always the digit will be 2 or 3.

Hi, belinea2010 Please try.......... =SUBSTITUTE((MID(A2,SEARCH(")_",A2)+2,3) & " kHz"),"_"," ") in B2 cell.

Hi, Please check if this helps you or not...