The discussions
Conditional formatting based text in another cell
Hello, I want to conditionally format the cells in one column (in my case) D, if the cell in the same row but in column K contains one particular ...
Creating new spreadsheet based on column - macro help!
Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a spreadsheet th...
Date formate in formula bar
hi Tried to change the date format in the formula bar but its not taking for ex: 29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet its ...
Help with returning multiple values
Hi, I have 3 columns in Excel. I need to search value from Column A in Column B and return value from Column C. For example I need to find 004 f...
Looking up and adding the values fixing different criteria
Hello, "A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated) "B Column" the size of each item such as 10mm, 20mm, 50m...
Comparing two columns with string
I have two columns :A (shorter list) and B (longer list). Is there a way to find all instances of B which may have any string from A? For e.g. COLU...
Transfer from one worksheet to another with a codition
Hello, all i have question I'm trying to populate a work book in order to organized my warehouse. on the first sheet i have 6 columns with the follo...
Need to add next loop in code
Thanks for this. i have little bit issue if you solve this Here is code, as you see i repeat code for next row and sheet calculation. i just want to...
Cannot open pdf file attachement in my email
Hello, I can't open my PDF file attached in my email. However, I have PDF on my PC and can open PDF file in Word Document, but not in my email. ...
Batch create ms project files from excel data
Hey everyone! I am hoping to be able edit a MS project template using a macro. With each project we do I have the project start date, task names, ...
Need vba code to create loops please
SolvedI have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...
Need help copying to another tab . .
Hello, I need to copy a row (multiple rows) if a cell in that row contains certain text. For example if C12 contains the word "expense" I need the...
Common part numbers on bom
I have many many worksheets within an Excel file. Each one contains a list of components used to make a final product (assembly). This is called a BOM...
Vba
SolvedI want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...
Macros or formula?
I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I need ...
Formatting cells
SolvedI'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...
The object is corrupt - in word 2003
SolvedWe have a document that has several objects (Excel tables) in it. We update the tables each month and then "save-as" the new month. We have one tabl...
Exchange 2007 corrupt database
Solved/ClosedI'm running Exchange 2007 Enterprise on Windows 2003. I have about 10 databaes that are running. I reboot the server this morning due to some updates ...
Cutting last 10 charecters of a cell and pasting to next cell
SolvedHi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...
Conditional formatting where 2 statements are met
Hello, I'm trying to use conditional formatting in excel 2010 where if the data in column D is 'In Progress' and the data in column N is a % betwee...
Prepare summary sheet order by items from variuos sheets in work
Hello, I need to prepare a consolidated summary sheet .(Basically Timesheet) The description of the summary sheet as below. 1. A master wor...
Microsoft project 2007 corrupting data
SolvedI have a split situation. At work I use MS-Project 2007 and at home 2003. To ensure transportability filers are always saved in 2003 MPP formats. ...
Opening a corrupted illustrator .ai file
SolvedWe have an Illustrator CS2 file, that a co-worker has been working on for the last month, that is now telling us unknown error has occured. We have...
Search using formula
I have around 10 sheets in excel say sheet name as 1 , 2 , 3 ..... I wanted to search a word in specific sheet and get the Number from the next cel...
Vba copy and paste range to next empty cell(s) to right
Hello! I'm fairly new to VBA, and I'm new here, so please bear with me as I try to explain what I need. I have a set of data that will be updated on...
Illustrator file damaged and could not be repaired
Solvedits been coming more and more common for my files to become damaged and not be able to open for me. It started with files that had an insane number of...
How to restore xls?
SolvedWe had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Offi...
Conditional text based on text in another cell
Hi, I'm trying to format a cell (D2) on Excel 2007 so that when the cell next to it (E2) contains "LFC-0.3", it will say "Downregulated", but if the ...
Date
what is the formula to convert numeric date into words in excel
Excel formula needed to count a list of names
SolvedHi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...
Automatically copy new survey data to another sheet
Greetings, I'm trying to copy certain cells of data received via an Excel Survey to another sheet. Trouble is, when new data is received, the row num...
Publisher 2007
SolvedHello, My computer crashed purchased a new one and am reloading software. I have my Publisher CD but no longer have the key. I called microsoft and th...
Partial match of names
Hello, On Excel, I have two seperate spreadsheets. The first is with a list of names, and the second with a list of names and emails. The second l...
Opening pdf files in photoshop
SolvedHello, I am having trouble opening my pdf file that I created using photoshop CS2. I can't seem to open this file anymore, previously I could open i...
Conditional formatting: find text and highlight from other cell
SolvedI have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...
Macros to add numbers
Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...
Change date format
Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...
Need a macro to searched data in another excel
Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...
Date format
Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...
Downloading files
Hello, I am having trouble when trying to open downloaded files in Microsoft Word 2007. The files will not open in English but some foreign langu...
Condition formatting on changing cell color based on another cel
hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...
To copy data to other workshet by suming the value based on co
Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...
Ms outlook outlook data file cannot be accessed " while accessin
SolvedI am unable to open my Outlook file due to corruption how to repair database .pst file of MS outlook. I was using Microsoft Outlook 2007 from last 2 y...
Auto populating from one spreadsheet to another
HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...
Need formula to populate total sales for each employee by month
Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...
Get data present in row1 of sheet1 copied into row1 of sheet2
SolvedHello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...
Unable to open a pdf attachment
Hello, I am unable to open up PDF attachments from one sender. i do not have this issue when opening PDFs from other senders. Configuration: W...
Outlook 2010 cannot open or access the required pst file
SolvedThi smorning a system has had a problem. When I try to open Outlook, I get the following error: "Cannot expand the folder. The set of folders canno...
Copying rows to certain worksheet
Hello, I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to...
Last value in a row
Hello, I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value a...