Excel Forum
-
VBA Excel help Colour a cell that contains 0 [Closed]
Hi, I have a table that displays data from another tab using VLOOKUP, although i have some cells that contain a 0 I have tried using...
-
Create workbooks from a list [Closed]
Hi I'm totally unfamiliar with Marco's, so I hope someone can help. I need to create 200 excel sheets from a template and save them with the...
-
Comparing 2 worksheets in Excel [Closed]
Hello, I wanted to compare 2 worksheet. If there is a different it return the as below Sheet 1: Apple vs Sheet2:Orange and if no...
-
Recalculation in Excel [Closed]
Hi friends I need a code. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. I press f9 once for...
-
need formula [Closed]
1. If the cell in coumn Q contains CEMEX, put the value of “CEMEX Reuqest” in the new column cell 2. If the cell in column Q...
-
Need macro copy info and save as new file [Closed]
Hello everybody! I have 2 workbooks: Timesheet (T), FTE report (F) All would be starting on second row, as I have a header row on the F...
-
Days from date and stopping counting issue [Closed]
Hello, I am trying to create a new tracking sheet, and it focuses around this forumula I can't seem to find out how to fix. The formula I'm...
-
Making my macro independent on future Sheets [Solved/Closed]
Hello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I...
-
VBA to copy only values and not formula [Closed]
I have this sentence in VBA that is working but it is copying the format as well . I really would appreciate. if you can tell me where to add...
-
Basic formula in spreadsheet addition [Closed]
basic formula in spreadsheet addition
-
Making formulas work, which work on other computer [Solved/Closed]
Hello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and...
-
Help creating a Macro [Closed]
Hi, I am trying to create a Macro to copy paste the particular range of row in the same sheet based on the cell value in the previous sheet...
-
VBA: Create sheets from list [Closed]
Hello, suppose i have value in column A from 1 to 10 then i want to create a sheet from 1 to 10 using macro System Configuration: Windows...
-
VBA Code - conditional formatting [Closed]
Hello, in VBA, I want to do conditional formatting of cells in a column with below background & font colours. Below 25: (RED Background-RGB...
-
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...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty