Excel Forum
-
Create new workbooks using a template workbook [Closed]
Hello, Any chance someone would know how to create a macro that would take an existing excel workbook template with data on Sheet1 and have the mac...
-
Modifying CASE function in VBA code [Closed]
Hi hoping someone out there can help. I'm reasonably new to VBA code and was hoping to modify a CASE reference code to modify cell colour based on ano...
-
I want data from 12 sheets to be transferred to a [Closed]
I want to great a master sheet out of 12 sheets. I am having a hard time doing this. Can I get your assistance? I ran various Macros already and can't...
-
Convert From figure to words [Closed]
Hello, Sir, How to convert in to words from figure System Configuration: Windows / Chrome 68.0.3440.106
-
Copy 5 rows at a time from the master workbook [Closed]
Hello, Is it possible to copy 5 rows of data from the master workbook at a time? I have approximately 10 sub workbooks where I would like each...
-
MACRO to copy / paste cell text down various rows [Solved/Closed]
Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...
-
MACRO submit data drop to next row upon submission [Solved/Closed]
Hello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...
-
How to auto transfer data from sheet A to sheet B [Closed]
Hello, pls teach me how to autotransfer data from "sheet 1" to other sheet "IAS2901" "IAS2902"... follow by the code in "sheet 1". this sheet1 da...
-
Recalculation [Solved/Closed]
Hi friends I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ...
-
Open multiple Workbook and populate them [Closed]
Hi, I've been working and looking for a solution/code for a while but couldn't find anything that would fully work. 1. 'Name details.xltx' is t...
-
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 conditiona...
-
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 name ...
-
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 different ...
-
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 eac...
-
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 contains C...
-
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 spreadsheet:...
-
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 workin...
-
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 believe is...
-
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 Value s...
-
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 when ne...
-
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 Sce...
-
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 / C...
-
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-255...
-
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 at th...
-
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 it e...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- Computer Boots to Black Screen