Excel Forum
-
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...
-
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 columns...
-
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 I w...
-
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 in A...
-
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 column b ...
-
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 55 it...
-
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 cell ...
-
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 should...
-
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 b A...
-
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 columns. ...
-
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). Ex: Compare ...
-
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 Result Transactions ...
-
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 woul...
