Hello, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in anoth...
Hello, Hello everyone...quick question...I need a formula to search data from two columns and find the single row which matches the specified criter...
Hello, Hello I am trying to copy a certain number of rows from sheet 1 to sheet 2 this number is dependent on a value i have set in sheet 3 A1. T...
Hello, I have a fixed report format named "Challan" which I need to prepare almost everyday with specific data. I want the macro by which by click...
Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...
Hello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...
Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...
Hello, I am attempting to put the time starting at 12:32:44 AM for 128 rows and click up the time by one second to 12:32:45 AM for the next 128 rows...
Hello, Sir I want change date format in 25-06-2018 to 25th June 2018 How can change 25 in Th letter in upper case Please tell me any one
Hello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...
Hello, I am attempting to take a range of data, in this case A1:I42, and copy it to a separate workbook. So I want to copy A1:I42 from Sheet 1 in ...
Hello, I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sh...
Hello, I want a VBA code for create a copy of one excel file that contains all the contents without macros and also I want to send that work...
Hello, I need help to changed from date to number? System Configuration: Android / Chrome 67.0.3396.87
Hello, I want to create copy command button through message box in VBA. In message box the information which is going to reflect should be copie...
Hi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...
I have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...
Sir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...
Hello, If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. Ex: Count...
The excel sheet below, shows different Items that are either purchased and paid up front, not paid or purchased through layby from AGRIQUIP. If Column...
hi there i just need to make 1 cell for a date but with auto population of slashes so if i type 21062018 in the cell it comes up like 21/06/2018 ...
Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...
1) Hi there, I'm trying to do a formula in a cell and need some help please. For the sake of this example, I'll be typing certain text into C31 and I'...
Hello, I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a secon...
I need help with counting days if there is not an end date on the report. Ex: Count the days from the admission date to the end of the month I am do...
Hi I'm new in VBA. My program should let the user choose a folder of excel files. Then it will automatically copy all of the first worksheet to master...
I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3 etc....
hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...
Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add...
Hello, I am using excel 2013 and I want to convert a range of data with variable no. of columns and 24 rows to a single column (columns stacked on...
Hello, I have a "Key" Code Value 000 Black 123 White and another sheet with the data below Data Colour BKI000T GTEF123X...
Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...
HELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WO...
Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it sho...
Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that there...
I have name of person in 1 row and multiple car names owned by him in different rows .How to combine these rows together so that name is in one column...
In one tab I have information, where I have made it output the information on a second tab (It's more in depth than this but I tried making this as si...
Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0
Hi, I am having an issue with a code I am writing. I want to insert 1,2,3,4 down an empty column X times ( where X will be inserted by the user)...
Hello, I'm trying to produce a simple excel spreadsheet on my Macbook which automatically changes the image in cell B3 when I change the name in A...
Hello, I am working on a work book in excel for work. On one page, I am tracking quoted / sold cases when a case sell, I have it change colors. ...
how do i install excell on my pc
Hello, 17/03/1996 in word
Hello, Using Excel 2000 charts, in some files, when I right-click on the horizontal (Date) axis, select the Scale tab in Format Axis, I get a "Time ...
I am new to this this and would be grateful for any assistance with a macro which copies the formula from the cell above and continues in a loop till ...
Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...
Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...
Hello Folks, There is something wrong with my Excel file. It was working fine on last night. Today, I opened it anf got the following error: S...
I have two columns which if equal(unless blank) I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify the ...
Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant w...