The discussions
Conditional formatting dates
Hi I am trying to format a date column on my spreadsheet and just can't see to get the formula right Simplified, I have 2 columns, one with a deadli...
Formatting cell
SolvedHello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...
Macro that extracts info from changing number of worksheets
Hello, I'm trying to find a way to insert a summary of several worksheets (I'm calling them analysis logs), but want to make it in such a way th...
Drop down look up
SolvedHello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...
Automatically update master worksheet from other worksheets
SolvedOkay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...
Help- conditional cell formatting
SolvedHello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...
Transfer data to individual sheets from master sheet.
Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...
Group duplicates and move to new worksheet
Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...
Auto populate from master to individual sheets
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...
Make a macro run when data entered in a cell
Solved/ClosedHello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...
Need help with #value!
Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...
Excel formula/vba assistance
Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...
Worksheet_selectionchange event not working
SolvedHello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...
Give a response by comparing 2 times (in different columns)
I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM...
Working out the difference in times between two columns
SolvedI have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...
How to load data from various sheets into one master sheet?
Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate number...
Excel macro to insert two rows.
Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in different ...
Convert in to rs in word
3456755332578097 convert in to rs in word
Inserting day of week along with date
Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome of: Su...
Multiple cell copy to a single cell
Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but,...
How to copy columns to a specific column header and repeat?
SolvedHello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...
Auto populate data from invoice.
Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn sell,...
Changing format of date in excel
Solved/ClosedHello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...
How to create new sheets by column with repeated values
Hi Have lines with various tables in rooms. Rooms numbers are in column, but sometimes room have 2 or more tables so room numbers repeats. Code s...
Getting rows from one sheet to populate to another
Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...
Max(if..?
hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...
Calculation using alphabet instead if number
Hello, Dear Sir, If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0 For example Numeric column > 9949 = JJDK 9949 ...
Copying formula by changing only one rule.
SolvedHello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...
Month and year format in forms in excel
Hello, Hello sir I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Nam...
Autopopulating multiple sheets from main sheet by date
Hello, My name is Ana and I have a situation. Every day we have hunďreds of rows with diffrent info about our customers. On column H we have cells...
Automatic add and sub
Hello, Hi everyone,I need help from u regarding excel formulas and workout basics.My question is..If i add particular row or column it should be a...
Looking to enter a name and then want it to be pasted in x numbe
Hello, Looking to enter a name and then want it to be pasted in x number of rows. Then enter a new name in the x + 1 row and want that pasted y n...
Vba macro loop
Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...
Compilation
Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...
How to compare a range of data in excel?
SolvedDear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...
Adding and subtracting using vlookups
Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...
Pictures insertion
Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...
How to use vba to loop copy and paste
Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...
Copy paste special values macro
Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...
How to update data of sheet2 in sheet1 with excel?
Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...
Use conditional formatting to highlighting cells based on name
Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...
Vba for copying from data entry sheet to corresponding sheets
SolvedHi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...
How to extract data using vba in excel?
Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...
Calculate a percentage when the values are text
I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...
How to count the number of occurrences in a range
I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...
Formula for unique id's following a predefined rule
Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...
Dates conversion
Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...
Reformat date field to plain text
I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...
How to give a students two ranks
Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...
Delete or insert rows in a workbook
SolvedHello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...
