The discussions
Sending problem.
hi, please help for this issue, i am geting all my email in inbox which i have sent. ***@*** Reply all| Today, 8:35 AM ***@*** To send th...
Macro to split the workbook in different worksheets
Need a macro for Excel that will copy rows from my spreadsheet into a new one if it meets certain criteria. In the example below, I want to copy a...
How to insert any word in a cell after a word
Hello, i wanted to insert a word for e.g "and" in a cell which after a word. Can someone help me with it Configuration: Windows 7 / Chrome 50.0...
Copy paste data from one worksheet to another using macros
Hello, I'm trying to have a macros run to copy paste from one workbook to another, however, I need the macros to recognize the last empty row to p...
How to copy names from one sheet to another with just a click
Hello! I am tasked with creating an employee assignment spreadsheet. I cant seem to figure out how to easily formulate clicking names (around 10) ...
Calculation of positions in excel
SolvedHello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
Excel macro's copy data from one sheet to another
SolvedHey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...
Numeric into word
ClosedHello, i am type the numeric for exp 123 how convert into words for exm one hundred twenty three in excel 2007
Complicated excel formula
Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...
Urgent copy vertical data from one sheet to another horizontally
Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...
Get a value from col a based on the max value found in col b
SolvedHello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...
Comparing dates in multiple columns and using one that matches
SolvedHello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
Auto populate into a different tab based on cell value
Hello, My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with d...
How to insert symbols of the french language
SolvedHow to insert symbols of the French language and keep them in a folder to use easily.Thks a lot. Please advise.
Create & name worksheets from a list and copy data
SolvedHi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
Vba macros help
Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...
Middle name extraction
Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...
Formatting whilst using letters and numbers
I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...
Conditional format make a row a color based on another cell
Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...
How to insert columns until a cell condition is met
Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...
Paste data from specified cells to another when just typing comp
Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...
Macro to get random samples based on condition
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.
If cell contains a word from a word bank, then return value
Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...
Finding percentages
Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...
Cell referrence
Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks
Lookup 2 cell headers one one sheet to find answer on another
Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...
Need only date from text
Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968
Recover gmail account
Hello, What if I forget my ID.. . Configuration: iPhone / Safari 4.0
Get value from cell to other sheet based on condtion
Hello, i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex: Cell A | Cell B ==============AB ...
Issue in excel
Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...
Excel dates
ClosedHello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
Excel 2010 doubt
ClosedHello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...
Can't open my 2007 document
SolvedHello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file is no...
Conditional formatting based on specific expiration date
Hello, I have a spreadsheet that tracks training my employees take. The cells include the dates (mm/dd/yyyy) that the courses were taken. Most of ...
Search then validate given values against given sheet.
I have two worksheets. One sheet is called "Valid" and contains values in the following cells: A1= 1234 A2= 123 A3= 12345 A4=123456 The other...
Not able to cut or copy attachment file
SolvedHello, I am not able to cut or copy any attachment file in outlook 2003.In a new message,i attached a file(pdf,xl,doc etc) i want to copy tha...
Formula question: "if" function with date
SolvedI am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...
Highlight cells with text that match data validation menu
SolvedI see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet tha...
Change cell colour based on other cells text
Hello, I really need help on this one as I can't work it out. I need to change the colour of a cell if that cell and the previous 12 cells do not c...
Keep drop down/ data validation with macro
Hello, I searched around a lot and could not find an answer to this: I need to replace values in a cell with a macro while keeping the "Data Valida...
Command button to move data from one sheet to another
Hello, I have a report with a data sheet and a data removed sheet. The data sheet is from column A:AC. In column Q I have different statuses tha...
Protecting a file with a password
How do I protect my Word file so that nobody can access without my permission in Windows 7
Converting currency to words
His Please convert 178 318.45 into words
I forget my gmail account password
Hello, I forget my gmail account password recovery email id password also same so I can't open my both accounts. please help me Configuration:...
Can't read pdf converted to word
Hello, i went to open my documents which is prepared by pdf in to word and the created word documents are not readble please help how i can solve it? ...
Formula to find out all the master id's
Hello, My first columns is a Master ID which is unique for every row. My 5th column is the item name where item name's do get repeated. I need a...
Copy potential data from one sheet to another if condition met
Hello all, thanks for taking the time to read this, I have a very specific formula request, or at least a request for direction on how to write/lea...
Need to match two values and return another value
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet A) ...
Compare data and summarize on seperate sheet
Hello, Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers to se...
Search/transfer patient data
Hello, If anyone could help me, it would be greatly appreciated. Ok I have a spreadsheet with different patient names. If they are inpatient then ...
