The discussions
If cell contains this text then....
Hello, Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple ca...
Insert picture in excel macro, after crop it, save it to a file
SolvedHello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...
Pictures keep pasting over each other when vba code executes
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
If function with multiple statements including vlook up
Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...
Unable to restore emails from .edb file
ClosedI decided to migrate to a new Exchange server due to the crush of my old server. And now I am on the Exchange server 2010. But I understood (too late ...
Need password
Hello, I for got my password Configuration: iPhone / Chrome 49.0.2623.91
Date if function
Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...
Find words within cell & put text and color in adjacent cell
SolvedHi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
What is the password for volume limit on ipod
SolvedOn my ipod chatmoatic, I was trying to figure out what the problem was with my volume. So I came to this spot that says "Settings" then, "Volume Limi...
Multiple if function with priority
Hello, I want and If function to have 2 criteria. Where one segment takes priority, I dont know how to do that. Currently I have =IF($R145="...
Conditional formatting based on other cells
I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...
Saving mails to a removable drive
Hello, I would like to know how I am able to save all the emails in my microsoft outlook to a removable drive. I tried exporting but it tells me tha...
Macros: copy invoice details from one sheet to another
SolvedWould be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
Changed psd file to pdf in error. how to change it back to psd?
Hello, I saved psd file with no extension, and then changed it to pdf by mistake. Now, when I try to change it to psd in a browser, it still keeps i...
Conditional format cells based on another cell and own cell
Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...
Different calculation based on cell text
Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...
How to open my corrupted rtf document
Solved/ClosedHello, Can anyone please investigate me how to open my corrupted rtf document? When I try to open it I am getting: Loading error Any suggestions h...
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...
