Excel Forum
-
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...
-
+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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Adding delimiters between value of two columns in excel sheet [Closed]
I have an problem, i made an excel macro for adding delimiters between value of two columns in excel sheet. Suppose i added delimiters between...
-
Generate workbook files from excel list [Closed]
Hi, I have an excel questionnaire. It like to email it out to persons on an excel list with email addresses, first names etc. The problem is...
-
CF using date to change Font/Backgroundcolor to another cell [Closed]
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...
-
Excel formula [Closed]
who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula
-
Auto Fill macro when data varies [Closed]
I need to auto fill as a step in my macro but because the data will vary day to day it's breaking! Can someone help me? I need to auto fill...
-
Logic or macro series created by entering single value in cell [Closed]
hii need solution for excel i have series which is to be called / created by entering single value in cell for e.g i hv to call series for...
-
Require macro or logic in Excel [Closed]
Hi i am looking for solution refer attached excel snapshot need to call or create predefined series in column by entering single value in...
-
Need to compare data on the work book by giving deferent colour [Closed]
Hi There are columns in a workbook with numbers in various cells. I want to compare values in each column with the previous column. Cell b1...
-
Script is really slow and sometimes crashes [Solved/Closed]
Hi, 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...
-
Need VBA Macros to copy specific data based on condition [Closed]
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...
-
Compare five Excel workbooks and copying matched data to new one [Closed]
I'm trying to compare five workbooks in excel and have matching column data copy the entire rows into a new workbook (ReportWorkBook)....
-
Help required to apply IF formula [Closed]
Hello, I need a favor to add multiple if formulas for below conditions Column A Column B Column C ...
-
Need Help Creating a Formula for EXCEL [Closed]
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...
-
Colour excel cell based on Regional Post Code [Closed]
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.
-
Formula Help [Closed]
Hi Friends- I am trying to generate a formula to help simplify a project I am working on. Here is what I am trying to come up with: I have a...
-
Need help with script or formula [Solved/Closed]
Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is...
-
Loop A1 value based on columns with value [Closed]
Hi guys, hoping you can help me achieve what I want to display in MS excel 2013. What I have is this What I want to achieve is...
-
Matching cells but exclude blanks [Solved/Closed]
Hello, 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...
-
Need macro coding for find, copy, and paste [Closed]
Hi Friends, I need a macro coding for the below example. In sheet 1 I have extracted webpage results like profile page it includes...
-
VBA Code for adding sheet from range specified in another sheet [Closed]
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...
-
Macro for specific worksheets [Closed]
Hi, I would like to hide and unhide specific rows by one toggle button in multiple worksheets. Could someone help me with specifiyng the...
-
Macro to compare cells in a table and populate max value [Closed]
Hi all! Hope you can help me out, :-D I have a Table in Excel (nicely named Table1) and it's full of data which cannot be sorted or columns...
-
How to remove links at once from all excel files in a folder [Closed]
Hi friends, I have a folder having number of excel files say like 100 files and each having copy links from other files. Can I able to remove...
-
Rounding up time [Solved/Closed]
Hi, 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...
-
Match and Paste [Closed]
Hello, I have two spreadsheets that have two columns that are similar and a third column that is only correct on the 2nd worksheet....
-
Automatically transfer data [Closed]
Hello, I am facing problem to make an excel sheet in which i want entry in a cell of sheet 1st automatically should be transferred into 2nd...
-
Adding formulas [Closed]
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...
-
Automatically copying columns from one work book to another. [Closed]
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...
-
Graphing student data [Closed]
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...
-
VBA compile Error: Do without Loop [Solved/Closed]
Hello, 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...
-
Inserting pictures from a file name that is made from 3 cells [Closed]
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...
-
Excel formula help [Closed]
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...
-
Sorting the highest value with dates [Closed]
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...
-
Conditionally copy col values from one sheet to master sheet [Closed]
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...
-
Compare of two column [Closed]
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...
-
Dates in Excel are all mixed up and won't convert [Closed]
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...
-
Help creating a VBA macro [Closed]
Hi - I just started a new job and I'm trying to create a VBA macro to automatically run for the P&L template I put together (smartview) using...
-
Problem with script in Excel [Solved/Closed]
Hello, 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....
-
Conditional formatting rule [Closed]
I was wondering if anyone could help me to set up a conditional formatting rule for a cell that may contain any text that has not already been...
-
MACRO to split data into multiple sheet [Closed]
I have a data sheet with below columns, would like a macro to split data into each tab according to cardholder_name if this is...
-
Auto copy excel cells to my systems [Closed]
Hello, This Lim, can i have some help to solve "manual things" problems? This is my excel worksheet (contains orders ...
-
Cell colour containing specific info [Solved/Closed]
Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a...
