The discussions
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...
Please explain this excel macro so i can adapt it for my own
Hello, I have practically 0 knowledge about macros but I need to complete this task. I found this question that is similar to mine https://ccm.net...
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 ...
Suddenly unable to send emails
SolvedI am able to receive emails just fine. Going to the webmail server on the web I can both send and receive emails. I've tried adjusting settings on my ...
Outlook 2007 cannot connect
Hello, I m Satish, Tried to setting outlook, but cannot connect, all trial email messages are pending in out box. I tried all your above sug...
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.
Digital id issue
Hello, hello sir am not sending any messages through outlook 2007 massages received but not sending . so one message highlight digital id pls si...
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 ...
Need help right now
Hello, SIR ,we are from PSENTERPRISE we are unable to send emails right now bcoz of that facing lots of problem our organization..whenever we trying...
Forget gmail id password
Hello, My email id password is send. Configuration: iPhone / Chrome 43.0.2357.93
Populate data automatically from pdfs to excel?
Hello, I wanted to know if there are any option to upload/populate data from PDFs directly onto Excel file automatically? I wanted to use it for i...
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...
My gmail account has been disabled
my gmail account has been disabled.How can i enable it? please help me.
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 ...
Unable to send mail
Dear My outlook mail outgoing not working please suggest. Regards, Thirumal Rao.L
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...
