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...
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...
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...
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 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...
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...
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 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...
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 ...
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...
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...
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 ...
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...
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...
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. ...
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...
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 Col.A Col. B Col.C Col H Col I 1 Payee ...
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...
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...
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...
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...
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...
Hello sir : I want to find the student position. But those student who fail in exam not incldue in the position.
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...
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. ...
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...
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...
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...
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...
who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula
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 ...
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...
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 ...
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...
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...
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. ...
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 ...
Hello, I need a favor to add multiple if formulas for below conditions Column A Column B Column C Result Transactions ...
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...
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.
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 col...
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 I o...
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 this Pleas...
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 exclud...
Hi Friends, I need a macro coding for the below example. In sheet 1 I have extracted webpage results like profile page it includes (Quality s...
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...
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? I ...
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 in ...
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 link...