Excel Forum
-
Excel compare and return result [Closed]
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...
-
Searching two columns and displaying a third [Closed]
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...
-
Copy certain number of rows using VBA [Closed]
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...
-
Create New Sheet with specific format from row [Closed]
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...
-
Highlighting future dates [Solved/Closed]
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...
-
Copy rows to other sheets based on value in column [Solved/Closed]
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...
-
Highlighting future dates [Closed]
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...
-
Copying time fields down [Closed]
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...
-
How to change date format in Excel? [Closed]
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
-
Make userform [Solved/Closed]
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...
-
Copy Cells to Separate Workbook Using VBA [Closed]
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 ...
-
Find in column and Copy it's row code for Google s [Closed]
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...
-
VBA code for create a copy of one excel file [Closed]
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...
-
How to change the format from date to number? [Closed]
Hello, I need help to changed from date to number? System Configuration: Android / Chrome 67.0.3396.87
-
Copy command button in message box [Closed]
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...
-
VBA code for copy & paste items for multiple times [Solved/Closed]
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...
-
Create sheets for additions to list on sheet one. [Solved/Closed]
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...
-
Overwriting data during transfer [Solved/Closed]
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...
-
Date Formula counting days [Closed]
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...
-
How to find the total tax? [Closed]
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...
-
Change date format in Excel [Closed]
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 ...
-
Comparing two columns in Excel [Closed]
Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...
-
Numerical value to appear in D31 automatically [Closed]
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'...
-
Autopopulate info from Master to individual WS [Closed]
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...
-
counting days on a report [Closed]
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...
-
How to get the first worksheet only? [Closed]
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...
-
Populate cells in worksheets from an updating list [Closed]
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....
-
VBA code for command button [Solved/Closed]
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...
-
Multiple text in a cell [Closed]
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...
-
Multiple columns into a single column [Closed]
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...
-
Vlookup where table arrary contains certain value [Closed]
Hello, I have a "Key" Code Value 000 Black 123 White and another sheet with the data below Data Colour BKI000T GTEF123X...
-
Compiling data in excel [Closed]
Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...
-
looking for VBA code. [Closed]
HELLO EVERYONE, I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WO...
-
Auto update of data from one sheet to other [Closed]
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...
-
Creating Excel Email Alert For Expiring Dates [Closed]
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...
-
How to combine/merge multiple rows into single row [Closed]
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...
-
Copying and looping data from one file to another [Closed]
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...
-
Convert date to the English spelling [Closed]
Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0
-
VBA - how to repeat a set number of values X times [Closed]
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)...
-
Mac VBA & Excel, auto change image based on a cell [Closed]
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...
-
Auto populate when changing from quoted to sold? [Closed]
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 excel on my pc [Closed]
how do i install excell on my pc
-
Birthday [Closed]
Hello, 17/03/1996 in word
-
Scale Tab in Format Axis in Excel 2000 Charts [Closed]
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 ...
-
Macro which copies formula down to end of row [Closed]
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 ...
-
When the field is =N, want to subtract that field [Solved/Closed]
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...
-
Conditional formatting across multiple columns [Solved/Closed]
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...
-
MS Excel file error message [Closed]
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...
-
Conditional formatting across columns [Closed]
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 ...
-
Data transfer from master to other sheets by type [Closed]
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...
Subscribe To Our Newsletter!
