The discussions
Conditional formating of cells
Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...
Copy data from one sheet 1 to sheet 2 only if text
Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...
Need help to macro my invoice number
SolvedHello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...
Search value error
SolvedHI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...
Selecting the different range of cells based on values
Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...
Information automatically updated
Hi, So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me havin...
Need help with conditional formatting.
Hello, I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Pl...
Searching and replacing dates
I need to search and replace dates. For example, in one row (representing one employee), all dates prior to 8/9/16 and replace those dates with 8/9/1...
Automatic numbering of invoices in excel
How do I create a macro for sequential invoice numbering in Xcel
Need a formula to compare two columns and return a value of 1
Good Morning, I need a formula that will compare two different columns and then return a value of one if certain criteria are met. The criteria: ...
Nested if statement not working
SolvedHello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...
Macro - pictures to excel acc to name
SolvedHi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...
Copy data from monthly workbooks paste in a single workbook
Hi Team, I want a Macro which can assist on the following time consuming task: I need to copy data from monthly workbooks (each having only 1 sh...
Unable to fill formula in the range which has been set.
Hello, I have created vba to creatable from the consolidated data in a sheet1. After a table structure is created, the macro will populate the val...
Help on running two code auto when opening excel workbook
Hello guys i need some help about merging two or more code on vba i used this code and it helps for only one code: Private Sub Workbook_Open() ...
Conditional formatting.
Hi, I have prepared a master sheet in which we enter the data. There are different sheet in the same file which will use the same data but not simult...
Formula please!
Hello, Can you help me with this data. What formula can I use? If 18:00 to 18:59 = 1 If 19:00 to 19:59 = 2 If 19:00 to 19:59 = 3 If 20:00 to...
Automaticaly populate activity sheets from master sheet.
Hi all, I am a volunteer working for an organization helping veterans. We run several activities as part of their rehabilitation and re-integration b...
If function help newbie
Ok here goes doing a very large spreadsheet and need some help with the if function If column a says A1 or B2 or C2 then columns D F G or what ever ...
Type a value in a cell based on another cell
Please Help me with this one i need to make vba to do that if ("A1") between 0 , 2.4 than ("B1")= 15 else if ("A1") between 2.5 , 2.9 than ("B1")=...
Need help with an if statement that refrences dates and values
Hello, I have a spreadsheet that has a bunch of maturity dates and corresponding return values. What I need to do is create an if statement that s...
Conditional formatting several cells risk register
Hi. I have a risk register where i want to apply conditional formatting depending on the probability (column b) and consequence(column c) I have a...
Vlookup or if
Hello, I really hope you can help. I have become very rusty on Excel. I am trying to create the formula where one cell content is checked agai...
Formula want to know (urgent)
There is a two values, i.e 200 & 300 in two cell. Now we want the values which is in between that figure in different cell means value should not exce...
Conditional formatting based on two cells (date and comment)
SolvedHi guys and dolls, I am hoping one of you clever people might be able to help me... I am trying to highlight a cell when 1. a date has passed ...
Macro to get the highest value in a table
A B C 10 1 apple 10 1 b...
Examination result
Hello,the are 38 pupils in the class,the position of the child is 31st,,number on roll 38 This is her result scores 63 :B :22nd :good 33 :D- :33rd ...
Help me with this one please
I like to display all the documents with "john salvatus" name. but only if the text in column C has "Overdue" in it and the column K has a null value....
If multiple cells contain value then add value
SolvedTrying to think of the best way to sort this problem! . I have a spreadsheet with a list of customers that have purchased a vehicle. Along side in...
Which free software for pc
can i get a softwere free for my pc if yes which one and how
Excel - formula for copying/moving a huge range in excel
Hi everyone, Please, I need some help with Excel worksheet. I have a huge excel worksheet with cell values spreading 50000 Rows and 900 Columns My ...
Comparing columns on two different spreadsheets
I have two lengthy spreadsheets and want to compare columns labeled "NAME" on each to determine which names are on either that are not on the other.
Odd and even cells
SolvedHello, I am trying to link cell C1 to cell F6. But if cell C1 is an even number I need it to add 1 to that number ( cell C1) and put it into F6. If ...
Copy data sheet 1 to sheet 2
Hello, hi sir i am doing one project in that my client want in sheet 1 data he needs expire date has to come sheet 2 please help me to do this...
Formula to compare 2 excel spreadsheets and find the difference
Hello, Would you be able to help me to find the formula to compare two excel spreadsheets? I want to see if items appears on both spreadsheets. Fo...
Function date range specific cells if & date formula?
I need to be able to pull data(other cells in the row) from a specific date range. My current formulas still need to be expressed but I only need i...
How to pull some data from 1 excel sheet to another automatic
Hello, How can I pull SOME data from sheet 1 (report) to sheet 2(table chat) automatically? Is there a way in excel, whereby if the data in one...
If and date functions
Hello, I am trying to figure out how to format cells based on a certain category. I have two different due dates depending on the category they fa...
Creation of dropdown from dynamic list using vba
Hi! If anybody could help me figure this out I would much appreciate it! I have been trying to make a Macro that can create a dropdown list from a ...
Helpp!! simple macro help!
Solved/ClosedHello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into a...
Remainder from excel vba on desktop or task bar
Hello, sir,i am venkat, when i am running the your giving I am getting task as empty, can you send whats the reason. Is it possible to get remai...
Formating dates
Hello, I am trying to do a VLookup between to spread sheets and having a terrible time with the dates formatting correctly. Each spread sheet com...
Fill color other fields based on start date and number of weeks
Hello, I would like to add the color to other fields based on the start date and number of weeks fields. Ex: In the attached xl, for instance, for ...
Two questions for cell color and sum
Hello, Please need help. Using excel 2013 If in column E "personal" or "business" displays then in that same row the cell in column J must change ...
Popup window when the excel file is saved/updated
Hello, I have an Excel file which is used by multiple users (saved on the network drive). They can only open the file as read-only. I'm looking fo...
Macro which should add a new worksheet
Hi guys, I have a question So I have a VBA Code which pretty much does everything it should. I can choose the CSV-Files, it deletes the columns th...
If formula help
SolvedHello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...
Creating a payback calculator with rate change
SolvedHey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...
Copy data from one sheet to another based on condition using vba
Hello, Please i need help on extracting some data in excel. The data looks like this A B C D 1 3.45 2.34 3.6...
Notice to purge data
Hello - Any information or help will be appreciated. Is there a formula that can alert data entry personnel when a particular entry, needs to b...
