The discussions
Automatically insert rows in associated spread sheets
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
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...
True or false value based on 3 difference cells' criteria
SolvedHello, 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
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
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
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
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
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...
Converting data in one column spanning three to four rows
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
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!
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
SolvedHi 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
SolvedHello, 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...
Conditional row copy/consolidate
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
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...
Macro for coloring cells depending on values and presenting them
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...
I need to create a formula if with dates and 2 variables
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
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
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
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
SolvedHello, 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
Check Register Col.A Col. B Col.C Col H Col I 1 Payee ...
Comparing two excel sheets and copying like data to third
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
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"
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
SolvedHello, 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
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
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
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
SolvedHi 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. ...
Cf using date to change font/backgroundcolor to another cell
Hello, Good day, can you help me how can I change the font/background color of another cell base from the list in another cell. Example in A...
Excel formula
who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula
Script is really slow and sometimes crashes
SolvedHi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...
Need vba macros to copy specific data based on condition
Suppose I file A which contains yearly data which we update on daily basis. lets say File A contains the data for year 2017 with following columns. ...
Need help creating a formula for excel
I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that woul...
Colour excel cell based on regional post code
I want the cell colour to change based on the Regional Post Code I have used in segmenting the UK. It's my own project.
Need help with script or formula
SolvedColumn A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...
Matching cells but exclude blanks
SolvedHello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...
Vba code for adding sheet from range specified in another sheet
Hi Everyone, I am not well versed with VBA. I m looking a code if any one can help. I have a fixed template in sheet"4" which contains the name o...
Rounding up time
SolvedHi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...
Adding formulas
Hi guys need help with some formulas I am currently trying to combine. the Rules is 1. If there is a "Form submitted" in the day I have to copy wh...
Automatically copying columns from one work book to another.
Please I need assistance with a problem I've struggled with for quite awhile. If I could write code I'm sure it would be quiete easy. My issue is: I...
Graphing student data
As a tech teacher, I run typing reports on my students each day/week. Each report is saved as a worksheet in a quarter workbook. The list of student ...
Vba compile error: do without loop
SolvedHello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...
Inserting pictures from a file name that is made from 3 cells
I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells. Picture location is as follows: ...
Sorting the highest value with dates
Need help with formula or script Where I need to look for the Van's highest Passenger# with the latest month available for example van 800's l...
Conditionally copy col values from one sheet to master sheet
I have 3 workssheets, Master , Billing and EA.I'm trying 2 diff things: 1. update the master sheet when either of the Offer or EA sheets are updated/...
Compare of two column
I have 2 columns column a have unique record in repetition and in column b I have non unique values ...now what I want ...I want to place the remark...
Dates in excel are all mixed up and won't convert
Hi, I downloaded some data from my bank for some transactions. Using MS Excel 2008 V 12.2 on a Imac 2015 I usually convert the dates to YYYY-MM-...
Problem with script in excel
SolvedHello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...
