• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by webmax

  1. W

    Msgbox when background query refresh completed using macro

    Hi, I am using power query to extract the data from the external website. Also this power query is running in background for every 30 minutes to fetch the data and update in excel workbook. My requirement is i need VBA macro code if the background query refresh completed then i need Message...
  2. W

    Error in Do until statement

    Can you provide where to do the changes in the code?
  3. W

    Error in Do until statement

    I have three values in the excel sheet B Column contains Opening stock C Column contains Sold units D column contains Closing stock I put the below macro code if the closing is less than or equal to zero the process should stop . But the do until statement is working more than that >>>...
  4. W

    Leave balance adjustment

    Hi I have attached excel with leave data with input and output In the sheet i have three types of Leave which is CL, SL & PL If the employee availed leave more than the Opening balance then the leave should be adjust with the next column. For example in the first data Mr. John has CL leave...
  5. W

    filter macro not working when merge cells

    Hi I have a excel file with three datas emp id , emp name and location. I separate the data based on the location filter I am using the below macro code. but when i make the heading as merge the below macro is not working. It filtered only the blank cells. Attaching the file for your reference...
  6. W

    Save excel file as separate file name

    Hi I have a excel sheet with two sheets and having 3 data inside that (Emp code, Emp Name and Location) Sheet 1 contains Format Sheet 2 Contains Data File it contains three data (Emp code, Name and Location) Now i want copy 1st employee code, name and location and paste in the Format sheet...
  7. W

    Unique Data Value Count in Excel macro needed

    I need macro code. I have already did formula. Based on that I need macro code
  8. W

    Unique Data Value Count in Excel macro needed

    Hi I have country name Data in A column. I have already put the Output Data in C2 Cell using formula. Now i am using the formula but need for this formula with used range count in A cell. Example now i have a data in A2:A8 Cell. But if i add more data then the formula will add to the used...
  9. W

    Sum Data based on city and level

    Hi I have data with 3 columns in the excel sheet attached. 1st Column is Region, 2nd column is Level and 3rd column is Marks I need sum the Marks based on the Region and Level Attaching the excel sheet with Input data and output Data Kindly do the needful Thanks
  10. W

    Days Calculation for Inbetween Joinees for salary

    thanks can we put the date inside the formula instead of adding two cells E1 & F1 cell. can you guide if that in that scenario.
  11. W

    Days Calculation for Inbetween Joinees for salary

    Hi, I have excel sheet with three datas A Cell-Emp ID B Cell -Date of Joining C Cell - I given my Output what answer will come Now i was calculating Salary for June month . One employee Joined on 6th Jun 21. I want if the employee joined before 1st of June then the output column will show the 30...
  12. W

    How to skip the excel contains cells while tabbing

    Hi I am attaching excel sheet with this In the yellow marked color cells contains formula. My requirement is if i Enter the data and give tab then the data which contains formula cells need to skip Example in this excel sheet If i enter data in B5 Cell and give Tab button it will go C5 Cell...
  13. W

    calculation on slab value

    hi Team I have a sales slab value from 0-5,6-10,11-20,20 & Above. If the salesperson sells 25 nos of the product the same will be calculated according to the slab value as a bonus instead of the overall bonus percentage. Attaching the excel sheet for your reference. Kindly help
  14. W

    Find unique values when blank cells

    Hi can you explain about the below formula. how it works Please try at J2 =SUMPRODUCT((B2:I2<>"")/COUNTIF(B2:I2,B2:I2&""))
Back
Top