Helo i need some formulas .e,g.TA,DA,HR,INTEREST% in like insurance. And Grade,%,fail,pass. Please help me undefinedHelo i need some formulas ....
Hello, Hello, I need a help if some one can help me. i a fresh in excel vba code writing. please provide a code to protect a cell with passwor...
Hi, I need to search and extract up to 10 lots of 46 sequential cells from column A containing 1400 cells. These 9 or 10 lots of 46 cells need to be c...
Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...
Hello, I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numer...
Hello, Not sure if what I am wanting is possible but thought I would ask... I have a database in which I will always update and add to. And ea...
Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.
Hello, I need to compare two columns with another two columns and return date from a third colum. Example I have a zip code with 90004 with 3 dif...
Hi all, I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example: ...
Hello, I am trying to write a logic formula in excel without using "if" in the formula. I want it to say if less then or equal to 10 the answer is...
Hey guys can you please help a desperate girl out lol I have a report I do every 2 hours at work through excel. I have two reports that go into a m...
Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate workb...
Hello, I want a macro to repeat a row n times. Example A B C if n=2 A B C A B C Thanks in advance
Hello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...
Hello, Please help i have to insert item pictures in column A i have item code in column B. All pictures saved in D drive folder name pictures. fi...
Hey guys, I have a report I do every 2 hours at work through excel. I have two reports that go into a macro and it's ran to go into several differe...
Hello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...
Please help i have to insert item pictures in column A i have item code in column B. All pictures saved in D drive folder name pictures. filname star...
As per the picture I have a spreadsheet that tracks what courses an individual has completed and if that course has a Certification attached to it. If...
Hello, I have a sheet, where at the top, I have a table of all orders in production. In column "I" you can set the status of the order using data ...
Sheet1 A B C raw 1 Org 2 Box raw 2 apl 5 Peti raw 3 bnn 3 Peti ...
dear sir, i want to formula for numeric value (Ex. 12,350/-) into word (twelve thousand three hundred fifty rupees only) please rep...
Desperately needing help with this one. -A1 to A25000 has a list of names. -B2 to B25000 has a list of the city the person lives in. -C3 to C2500...
now i can not open microsoft excel 2013
Hi, I am trying to create a speadsheet based on customer sales. In one cell it has "yes" or "no" to inform me on whether or not the customer is commi...
Hello, I have data in template sheet and want to copy all the data from template sheet to sheets after template sheet but the no of sheets is not ...
Hello, I have three print areas in a single sheet. If I print that sheet, it prints 3 pages(print areas). Is there any way to print only the p...
I am looking for VBA code for below problem. there are three sheets in excel 1.Raw data (see in attached excel workbook) 2.Criteria 3.Result ...
Hello, I'm currently using a macro based on the wonderful solution presented here: http://ccm.net/faq/6669-excel-worksheet-auto-generator I hav...
Hi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...
Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
Hello, I have an excel sheet with tones of information on for my customer I want to capture savings made and automatically transfer the date ont...
Hi Guys, I currently have a tonne of data that is dumped in a sheet called Unsorted Raw Data. I would like to create a macro that allows me to co...
Hello, I am trying to match the requests processed by the bank with the requests sent to the bank for processing. The bank could process part of ...
Hello, I have 2 sheets. 1 sheet contains calendar months along one axis, and different positions (jobs) along the other the axis. My 2nd sheet co...
Hello, I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project. I've created a...
Hello, I have a list in a column need to create sheets with each value in the list. The list will have duplicate values. but excel cannot have two s...
Hello, Is it possible to hide page breaks in excel while shifting from print preview to normal view using vba? I know to remove pages breaks ...
Hello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
Hello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. ...
Hello Everybody, As shown in attached fig. I want to write in foundIn colom if a text in authors colom is present in Publications colom. If it is fo...
Hi, Hope all is well. I was wondering if you can help. I cannot figure out the formula to automatically add text to one cell base on another c...
Dear all In MS excel column B is names of more than 100 staffs,column A is date of payment, column C is bill No (RA No 1-20), column D is amount bi...
I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sh...
Hello All, Can you please help me to make VB program for an excel file. Basically I want to copy the data from an excel work book which is located...
Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...
hiya, i have three sheets: sheet 1 - detail is input manually someone's name and personal details sheet 2 - a sheet that takes some detail f...
Hello, I want to count the number of days from start date to end date. ie. 1/2/15 - 1/4/15 is 3 days.
I am needing some help with a formula...if possible. I have numbers from 1-85 listed in column F. These numbers can appear multiple times. I have a v...
DON'T MISS