Excel Forum
-
Separating records by relocating cells [Closed]
Hello All, I need to automate the following process: I've an excel worksheet that is (columns x rows) 19 x 260 size, arranged as...
-
Adding days to dates [Closed]
Hello, I was hoping someone could help with this, I am creating a spreadsheet and am having problems with the following: Column D shows...
-
join the formula [Closed]
=IF(ISBLANK(C17),"",IF($L$14="INTER STATE SALE",(M33)))&IF($L$14="STATE SALE",(I33+K33))
-
Adding days to a date based on drop down menu [Solved/Closed]
Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year) I would like column F to add 35 days if...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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'...
-
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...