Excel Forum
-
Use a checkbox to copy a row and paste at end [Closed]
Hi, Relatively new to VBA so please bear with me. I am looking to add a checkbox button that when clicked will replicate the row of data...
-
Multiple IF statements in Excel [Solved/Closed]
Hello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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. ...
-
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...
-
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:...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
DON'T MISS
- Facebook Confirmation Code Text Not Received
- GTA Vice City Cheat Codes
- How to Download Instagram Videos
- How to Block Private Numbers
- Credit Score
- Sign Up for a Free Netflix Trial
- No Sound from Headphone Jack
- Reverse Image Search with Google
- Writing Professional Emails in English
- Get the Transcript of a YouTube Video
-
Grammarly Keyboard
-
Amazon Fire TV
-
OnLog
-
Tricount
-
Citymapper
-
YAZIO
-
Candy Crush for PC
-
CallApp
-
Garena Free Fire: Spooky Night
-
30 Day Fitness Challenge-Workout at Home
-
Pokémon Masters