Hi All
I am trying to format text in a string. I receive this worksheet from third party and I have to print visiting cards using this information. Data received contains lot of formatting errors like upper and lower case, double space between words, which I cleared the most of it with the help...
Hi All
I have data in “column D” in my work sheet, which is derived by formula and now I want to select a range of cells with VBA code in “column D” after the cell “D1” of the worksheet till the last row with the Real Value ignoring the cells with formula result “Blank” below the last Real value...
Hi All
I have 23 combinations from column A to E and in column G…. I want to give each combination unique number. At present I am doing it with IF function and it's working fine as I am using office 2007 but it is too long and any small mistake can be painful. Is there any shorter way to do it...
Hi All
I have a Excel file with open event which hides the application and show only user form but the user form is small in size. I want the form to open in Maximized State.
any help?
Regards
Mandar
Hi Everyone
I am using a vba code to automate the process.. In which at the end I copy the last worksheet into new workbook and close the original workbook.. Now in this code I want to add one more step i.e. saving the new workbook at the same location of original workbook with the file name as...
Hi All
I am trying to split the text string in to 35 characters in each line. And if the 35th character is in between a word the string should split whole word to the next column and in next column count 35 characters and again split for next column..
I am trying an array formula in first...
Hi all
I am trying to generate the list from string values that are separated by comma in a range with the help of code
But the problem is every time I have to change the code manually to get the desired list in desired column. Can it be done with single commend button click without changing...
Hi all
I have a worksheet with employee’s data where some cells are highlighted. Now I want to make a new list of only rows that are highlighted with green color in new workbook. I don’t want to sort the list by color as I need the original sequence of the list. How to do it please help...
Hi All
I need to generate the barcode (code128) for the membership card number. At present I am generating it with the help of other software and copy paste each barcode manually one by one in the sheet. Is it possible to generate the barcode in excel itself??
Thanks
Mandar
Hi everyone my question is:
I have an excel sheet containing membership number say 2827000001 to 2827005000 in column A now I want break it down into a batch of 100 and put the batch number in column B in front of each membership number automatically. i.e. Column A row 1 to 100 - 2827000001 to...
Hello
I am trying to create a “tour for the period calendar” of employees please help me in this.
I have Employee Number in column A Tour Start Date in column B Tour End Date in column C of sheet 1. Now in sheet 2 cell A1 is the from date and cell B1 is to date i.e. 3-May-2014 2-june-2014...
hi
i want to print some ID Cards and i have all variable data in excel i.e. name, id no, address etc. I can print merge it in corel draw it works fine but i am not able to create image link in excel to print merge it from the directory where the photos are saved. is it possible if yes please do...
hi
i need help in reorganize my data
i have a data in column A - H row 1 - 5000, we can call row-1 column A-H one record
now i want to shift records in a way that row-1 column A-H record 1, row-1 column I-P record 2, row-1 column Q-X record 3; this way 5 records and then next 5 records on row-2...
hi i need a formula to determine grade of student based on marks obtained by them.
GRADE A GRADE B GRADE C GRADE D GRADE E GRADE NO
MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX
80 100 60 79 40 59 20 39 1 19 0 0
STUDENT MARKS GRADE
ABC 93 A
How to do it
please help
How to find first empty cell in a range of cells in a column from the bottom with the help of formula
Please help!
Col A
20
12
29
24
38
<= A8 this is the ans
28
10
Regards
mandar
hi all
I want to calculate Loan Principal Amount when i have information of Interest Rate, Monthly EMI, No of payments.
i.e. Rate of interest is 18% P.A. for 5 Years (60 payments, 12 payments per year) and the EMI is 10157.38 now i want to calculate the Loan amount. can it be calculated with...
Hi
I have a problem in a spreadsheet where there is data in cell A1 to Q7000 and I have some error in some cells and colored it with the help of conditional formatting. Now I want to count the cell that contains error. In short I want to count cells that meet the condition in a range of cells...