Excel Forum
-
Automatically insert rows in associated spread sheets [Closed]
Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...
-
Formatting a cell containing text [Closed]
I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...
-
Copying data to a separate sheet but only when text is present [Closed]
Hello, I have a long list of data and want to transfer the data which only has a launch date allocated to a separate sheet as a summary. And whe...
-
IF formula needed [Closed]
Hello, I need a formula that goes like If cell 1 > cell 2 then write "winner is column A header " if cell 2 > cell 1 then write "winner is col...
-
Microsoft Excel training [Closed]
I want to complete knowledge about excel what's doing work properly
-
Pop up alerts even if Excel worksheet is not open [Closed]
Hello, I only have basic knowledge in advanced excel and zero knowledge of vba and macro. In one sheet of the workbook i have a list of employees...
-
Data auto population [Closed]
Hello, I have to maintain record of calculate PPM for day, weekly, monthly, year, and supplier-wise contribution to that PPM by just feeding it onc...
-
How to average a time field format 00:00:00 (hrsminutes/secs)? [Closed]
have a document that won't average a six digit time field. need to convert to ?
-
True or False Value based on 3 difference cells' criteria [Solved/Closed]
Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
-
Copying rows with data from multiple sheets to one master sheet [Closed]
Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...
-
Saving input into 2nd worksheet while keeping the 1st empty [Closed]
Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...
-
Compare and separate data [Closed]
Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...
-
Inventory Master List Help [Closed]
Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....
-
Record Scenario Iteration Results macro [Closed]
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...
-
Record Iteration Results [Closed]
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations and record the ...
-
Creating an auto updating sheet based on copy paste information [Closed]
Greetings and salutations. I've been trying to figure out how to create a score card sheet for our field technicians based on some automatically ge...
-
Copy data from workbook to another work book using date range [Closed]
Hello, i am new to this form and need some assistance in solving my problem i have below code which copy data into same workbook between 2 date ranges...
-
Reading text file containing data and output data in excel [Closed]
Hi, ...
-
Send reminder email 3 days before the date [Closed]
Hello, I'm new at this, any help will be appreciated. I need excel to send automatic email 3 days before expiration date. On my sheet theres...
-
Converting data in one column spanning three to four rows [Closed]
dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...
-
Macro for coloring cells according to the value of the cell [Closed]
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Macro for coloring cells according to the value of the cell! [Closed]
Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...
-
Repeating a simple macro loop up to 1,500 times [Solved/Closed]
Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...
-
Excel external data connection not working properly [Solved/Closed]
Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...
-
Highlighting Multiple Cells When Using Complete or Partial Text [Closed]
I currently work at a distribution center, and each day we perform lane assignments for outbound products. Attached is an image of our lane assign...
-
Value look up [Closed]
Hello, On excel I have a master Sheet that I enter Names of people which is used to transfer the names to other sheets making it simple to print. H...
-
Conditional Row Copy/Consolidate [Closed]
Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...
-
How to create a macro to copy and paste [Closed]
How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...
-
Auto create new columns [Closed]
Hello, I have a spreadsheet where I track attendance for my church throughout the year. We have events that happen on a daily basis. Most days I o...
-
Macro for coloring cells depending on values and presenting them [Closed]
Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...
-
Index formula questions [Closed]
I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that th...
-
Using VBA macro logic in Excel [Closed]
One static Excel workbook with a ton of raw data that has a static number of columns (A-EK) that is always the same but the lines (1-X) is not static ...
-
Macros [Closed]
I have a spreadsheet of 15000 lines, I need to copy the Cell ranges B:E onto the next line B:E, then go down to the next populated cell and do the sam...
-
Help creating macro [Closed]
Hi, I have multiple excel sheets in multiple folders. I want to copy part of excel sheets which are in multiple folders and paste it in a new excel sh...
-
What function of Excel does this? [Closed]
Hello, I know there must be a function in Excel that does this but I don't know what. If you know, please share or if I need a piece of code then ...
-
I need to create a formula IF with dates and 2 variables [Closed]
Im trying to create the following formula in excel If theres number greater than 0 in a column and if the date in the other column is before one mon...
-
Compare two column from two different sheets [Closed]
Hi...I want to compare two column from two different sheet which contain time and date.In sheet A column with date and time.In sheet B , there are two...
-
Search option did not getting in Filters [Closed]
Hi All, Hope you doing well !! When I update fliter in my Excel sheet then I did not getting the search like this, please find the snip below. ...
-
Urgent Help-VLookUps in Excel [Closed]
Hi, can we compare 2 excel sheets in which we have date related to Emails ID'S (Email recipients) but one sheet is having 230 rows and other 160 , i n...
-
Create a date from 3 different cells [Solved/Closed]
Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...
-
Check register with VLookup [Closed]
Check Register Col.A Col. B Col.C Col H Col I 1 Payee ...
-
Comparing Two Excel Sheets and copying like data to third [Closed]
Hello, I used the below answer and it works but i actually need to tweak it to copy from the second sheet. So I have sheet 1 has full data and co...
-
Creating a Calendar that autopopulates from multiple sheets [Closed]
Hi all, I am attempting to make a calendar that will auto populate or vice versa from multiple other sheets. This is all to track training hours fo...
-
+1 for every letter "S" [Closed]
I am trying to add 1 for every letter "s" between C5:C53,F5:F53,I5:I53. So far I have this formula =SUM(IF(C5:C53="S",1,0)) Which is giving...
-
Macro to insert multiple rows between existin [Solved/Closed]
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...
-
Conditional Format help [Closed]
I have an excel spreadsheet set up with 4 columns: Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date What I wo...
-
Student position formula [Closed]
Hello sir : I want to find the student position. But those student who fail in exam not incldue in the position.
-
Macro for creating separate files with fixed password from colum [Closed]
Hi All, I need urgent help for a macro which will create separate files from a column value I have this data in the picture attached http://sta...
-
Copy and past the not equal value using macro [Solved/Closed]
Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...
-
Free tools to compare data between two excel sheets [Closed]
Hello, I need to compare 2 excel files and find the difference in data which needs to be highlighted. Though there are many online sources to c...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video