Excel Forum
-
Copy defined columns data from several Worksheets [Closed]
Hi, I need a VBA code to copy the predefined columns (5-6 Columns) data in new excel and also need Refresh code to erase all data it has captured p...
-
Help with inventory tracking [Closed]
Hello, We're using excel to monitor our inventory. We all have pretty basic excel knowledge. We'd like to be able to track our stock levels with...
-
Excel text to date conversion [Closed]
I have column having values like Wed Feb 07 13:39:40 PST 2018; i want to convert to new column as standard date time format. Any clues ?
-
Copy Value from new Workbook to existing Workbook [Closed]
Hello, I have new workbook file which is generated every month (every 1st date of the month). The Workbook Name will hava a format like "Historica...
-
Help me convert a date format in Excel [Closed]
Hello, I need to add the REPLACE, or anything else that convert a date inserted with dots into a date format with slashes, to a long IF formul...
-
Scroll bar for single cell [Closed]
Is it possible to add a scroll bar on a single cell which contains too much text ?
-
Picture directory [Closed]
Same kind of scenario where I need to pull in a picture from a server folder into my spreadsheet from an ID number for a person. Sheet 1 has my ra...
-
Excel Macro Program [Closed]
Dear friends and experts. Greetings for the day !!! Can someone please share with me some ideas on my problem on Excel VB. Thanks in advance for you...
-
Need macro to copy paste @ variable [Closed]
Hello, Let us say i have a standard distribution of hours in a row as per below example. A1 A2 A3 A4 A5 A6 Jan Feb Mar Apr M...
-
Macro Auto Run at specific time [Closed]
Hi, I am new to excel macros and I have an excel with auto mailer macro. This excel will be updated regulary by team members. Now I want to schedule t...
-
Excel VBA Code for Min(SumIf() - SumIf()) [Closed]
Dear Members of CCM Forum, I thank you all for your great and tireless effort to help the world. I have been using the excel formula: =MIN(SUMIF...
-
COPY ROW BY ROW based on pattern matching [Closed]
i have the following data in sheet 1 A B C D E F day Pe M...
-
Difference between delete and clear [Solved/Closed]
Could some one explain both function ("Delete" and "Clear" in Excel) ?
-
VBA Macro - Scan worksheet for specific value [Closed]
Hello, Looking to create a VBA macro on Excel which scans a worksheet on the document for a specific value(s) and then tally up the results and ex...
-
If a column has a value add to another column? [Solved/Closed]
Heya, i hope someone can help me with this. I currently have a very large formula sheet made up so i can input a value and add it too my total along w...
-
Create rows based on input in columns [Closed]
Hello, I have a below table: And I would like to create the following automatically: Is there any easy way to create it? Thanks a lo...
-
If value is >= 10 then send Outlook mail [Closed]
Hello, I m now learning vba now but cant solve my issue at work What I want to do is ...in one of my excel worksheet , in column G, for any cel...
-
Excel IF statement [Closed]
Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has "Yes" then I want the todays date to sho...
-
How to change format from mm/dd/year to dd-mmm-yea [Closed]
hello Seniors, please solve my query: I need to change format of data in my excel sheet, for instance data is in the format of mm/dd/year while I ...
-
Conditional formatting [Closed]
Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire ro...
-
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 follows; I...
-
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 Date E...
-
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 "Le...
-
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...
Subscribe To Our Newsletter!
