Excel Forum
-
Find and replace in Excel Closed
Hi, This question is related to Excel 365. I have Sheet1 that has two columns. I Just gave a sample of word abbreviations. It has around 800. ...
-
If function with printing tool Closed
I have 3 column " Nu, Item, QTY" I want to print the cell who has a qty with the same Nu sort. nu item qty 1 ...
-
Populate separate worksheets with data from main worksheet based on criteria met Solved/Closed
Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...
-
Incorrect date while saving csv format Closed
Hello, I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens...
-
Picking data from a table Closed
Hello, I am going to apologise once again in advance as I am terrible at coming up with the right question when it comes to excel formulas hence why I...
-
Excel IF formula - Priority setting Closed
Good day I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indica...
-
VBA comparing two files via rows and copy difference to third file Closed
Hello everyone! I'm new to VBA and need your help! I need two compare two files (File 1 and File 2). I need to compare rows in File 2 to rows in Fil...
-
HELP with IF function Closed
Hello, So I have a problem with my file. I need to use IF function, but I don't understand. The main thing is that I need to calculate the days tha...
-
Excel Closed
I am trying to change date format to dd-mm-yyyy, but the format remains unchanged
-
Copy-paste some grid in excel Closed
Hi All I know this topic is quite old by now but. Haven't found the solution yet. I tried to copy-paste some grid in excell when i noticed. It wasn'...
-
Conditional formatting Closed
I want to make a formula in excel that if a cell in one column is not filled in within 7 days from the day in a cell in another column but in the same...
-
Paste value on filtered cells Solved/Closed
Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...
-
Regarding all fields by selecting individual ID Closed
Hello, I have a JSON file it contains 100 IDs and all their details, but when I type ID I need to get entire details of that person from JSON file...
-
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...
