Excel Forum
-
Formula I should use [Solved/Closed]
I am so confused on what formula should i be using for my work...? Which should be ending up like this...
-
Excel Cell Color change from another cell date fill up. [Closed]
For Example, 1 item due date is 10/Nov/18 & showing yellow color. when the next cell will in-house 9/Nov 18 than the previous date color will move fr...
-
Compare Excel sheets using Python [Closed]
Hello, Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you plea...
-
A combination of SUMPRODCUT/ISNUMBER with LOOKUP [Closed]
Hello all, hoping someone can help CELL (A) I have a question where, I have a column of data where there is a missmatch of data. CELL (B) I ha...
-
Background formatting from two values drawn from formulas [Closed]
Hi. I've created a table displaying prices from suppliers. On the end two columns I've added a formula to show the header of the colomn which holds t...
-
Duplicate line and decrease Id number [Closed]
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row w...
-
Conditional Formatting using dates/data in an adjacent cell [Closed]
Hello, I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B, hol...
-
Copy and paste one cell into 48 and then repeat [Closed]
Hello, I've tried to piece together how to do this function and I feel like it's simple but I need help please! Here's the recording for 2 times. I...
-
Python code [Closed]
Hello, The script above to compare two excel sheets and copy like data to a third sheet works great. What would be the opposite formula? Two compa...
-
change excel format [Closed]
Hello, how do i change the excel format of 02.07.2018 in to 02-july-2018 there is no option in Custom format because the separation is in ( ....
-
Inserting pictures from folder using macro [Closed]
Hello, I would appreciate if someone would help me. I never used macro until today and I searched for a solution but I just don't understand. Th...
-
Macro to check value in various cells [Closed]
In column B. I need to check cells in random order. If there is value then display msg box. For eg If cell B3 value = ABS then msg box "Please us...
-
Comparing two columns using partial match logic [Solved/Closed]
I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...
-
Automaticly change currency format in cell [Closed]
Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make...
-
Trying to create a ticket log spreadsheet [Closed]
Hello, I am trying to create a ticket logging system for my team at work and have created a sheet with 4columns each with drop down lists for sele...
-
Generate simplified data from RAW data [Closed]
Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some preci...
-
Copy rows to rows on another worksheet if " ✔ " [Solved/Closed]
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...
-
Auto populate weekday from a separate date entry [Closed]
Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically insert ...
-
Pass fail result including absent is fail [Closed]
One student passed in 5 papers out of 6 papers but 1 paper absent in this exam.actually this student is fail.How to calculate the result in excel
-
If, Time, Text, Blank Cell [Closed]
Hi, I have multi shifts as under; 6 to 14 = 8 7 to 14 = 7 14 to 22 =8 22 to 06 = 8 22 to 7 = 9 I am using =IF(E3>=D3,E3-D3,24-D3+E3)...
-
Create a macro for a data set [Closed]
m trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar
-
Excel calculator issue [Closed]
Hello, I am trying to create an excel calculator to calculate the holidays a certain employee has accrued depending on a set of conditions. I want...
-
VBA command button [Solved/Closed]
Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...
-
VBA - Button saves TextBox data in dif. Workbook [Closed]
Hi Everyone, I need some help creating a code that will allow me to save data input into a TextBox to a different Workbook called "FoundData.xlsm"...
-
Count total quantity by date into month [Solved/Closed]
Hello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...
-
How to use conditional formatting 30 day notice [Closed]
I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30 day a...
-
Lookup or match [Closed]
Hi, I have a column in which I have a value I need to look up, then in same column anther value I need to find then return value in column that has an...
-
Copying specific cells [Closed]
Hello, I am trying to use a command button to copy information from specific cells in sheet 1 to a excel form I made in sheet 2. The cells are not...
-
Saving multiple Excel files based on a list [Solved/Closed]
Hi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my problem....
-
Count Qty by mth to the order date [Closed]
Hello, I need a formula that helps me calculate the quantity by month to the order date and also by venue and type. I have tried to use a Pivot Ta...
-
VBA code to copy and paste data multiple times [Closed]
Hello, is it possible to parse a column and find a value in it, and copy and paste a particular range based on that value in the previous range? t...
-
Insert blank rows in table range [Closed]
Am trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar Dammam - KSA Riy...
-
VBA: Determine Conditions for Copy/Paste Process [Closed]
Hi guys, first time poster here :) I would need some help defining my copy/paste process. The situation is as follows: - I need to search for s...
-
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...
