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...
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...
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 ?
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...
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...
Is it possible to add a scroll bar on a single cell which contains too much text ?
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...
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...
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...
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...
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...
i have the following data in sheet 1 A B C D E F day Pe M...
Could some one explain both function ("Delete" and "Clear" in Excel) ?
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
=IF(ISBLANK(C17),"",IF($L$14="INTER STATE SALE",(M33)))&IF($L$14="STATE SALE",(I33+K33))
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...
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...
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 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...
Hello, Sir, How to convert in to words from figure System Configuration: Windows / Chrome 68.0.3440.106
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...
Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...
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...
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...
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. ...
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...
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...
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 ...
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 ...
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...
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...
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:...
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...
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...
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
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...
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...
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...
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...
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...
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...