Hello, Sir i would like you to help me on the following problem, i am filling an application form and i have done everything but on the date side ...
Hello, The code gives prompts me to enter the column on which the split needs to be done, but soon after that thrown an error:Run-time error '1--4...
i need to update a spreadsheet on the progress of documents being approved. i want to create a function that states if the document is "approved" (...
Hello, I wan to know how to send reminder mail from excel when it open and when before due dates of 3, 7, 30 days before multiple reminders I wan...
Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...
Hi all I'm pretty new to macros and I have been unable to find the answer to this question anywhere. I'm trying to write a macro that will selec...
Hello, I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help m...
I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column ...
Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...
Hello, I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex. CASH OVER/SHORT 04/01...
Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you don't ...
Hello, I have written code to prompt the user to state how many new sheets they want to add. But I need for the data on the "Main" sheet to always ...
I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...
Hello, I am trying to create a sheet that references items if they are selected from another sheet from a drop down menu. IF they are selected then...
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...
Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one workshe...
Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...
Hi, I am trying to calculate the number of months between two dates that relates to a specific time frame (financial year). Is anyone able to su...
Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...
Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...
Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...
Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...
Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...
Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...
Hi, Need a bit help for now. I am going to make transmittal that has two sheets which includes input(data) and output(transmittal). This will be my tr...
In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
Hello, I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data ...
Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
Hi, I am working on two different workbooks, one of them is a scorecard and the other is the data entry workbook, I am trying to copy a lot of cell...
I am trying to write code that will allow me to place an "X" in column A. In response I would like the cells in that line (B:E) to be copied into the...
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
Hello, First, thank you for taking the time to help me understand how to execute this comparison. I have an excel file with two sheets. I need ...
Hello, I would kindly appreciate your help in getting an answer to my question, which is, I have used "Find & Select," specifically Find & Replace...
Hello, I have used "Find & Select," specifically Find & Replace dialogue box to find specific values/data and then REMOVE, CUT, and Move to anothe...
I want to put an email address in a hot key so I don't need to type it ever time.
Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...
I want to know how to perform a macro for automatic invoice number combined with letters at the beginning for example XZY0001
Hello, when i input R in cell, it shows a tex "ok" Or "Not Ok" in another cell
While I see many VB solutions 'almost' there, I don't see a solution for me. Challenge is I have client data where each set of data has 'Patient Code...
Hello everyone, I'm trying to compare a table from one sheet to one on another sheet, and was wondering if its possible to copy the conditional forma...
Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...
Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
Dear All, I have a set of data covering 9 columns and 62 rows. (A1:I62). Now I want whole data of column 6 (F) to be changed to another data and so...
Hi, I have two spreadsheets with same columns from different sources. I'm trying to use a 3rd spreadsheet to compare the two & show me any diffs. I...
Hello, Arrow keys are not working in my laptop. System Configuration: Windows / Chrome 57.0.2987.133
Hello, I want to create an excel sheet for data entery. There will be a two cases. Case-1:- The value of one cell is equal to value of another ...
Hello, I'm making an quote workbook for an organization and I've run into a problem. On the first sheet "Main sheet" I input all of the transa...
Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....