The discussions
Using a data validation and an if formula in the same cell
Solvedhi, I have a spreadsheet in excel 2010 where one of my columns uses a dropdown list using the 'data validation' function. The list details several ...
Writing macros
Hello, I am trying to find code that will let me add roles into my data base on a name and then sub-total that information. Please help... Thanks
Filtering with spaces between rows
Hi All, Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :( thank...
Conditional formating: duplicate value in range of cells
Hello: Using Excel 2010, I'm trying to set up conditional formatting to see if a particular value in column A2 is equal to a value listed anywhere ...
Lock only a few cells on a worksheet
Hello, I have an excel file having many formula and I want to lock all the cells having formula. Whatsoever cell address, it could be D1, E9, J10,...
How to get multiple rows of info into one row
Student schedules were sent to me on several lines (one line per class) so each student has from 5-7 rows of information. I want each student to have ...
Microsoft project
SolvedIs anyone using MS project? is there a tutorial for this software somewhere on line?
Different currencies
SolvedHello, could you please advise what could be the best way to show in the same table different currencies. Lets say there would be a button which w...
Vba lookup
Hello, I currently have a macro built that takes a value from a specific cell and looks against a lookup table in another work sheet. If the valu...
Nested if formulas with times not caclulating correctly
I have several start/end times and need to also calculate the difference in minutes of those times on occasion. START A END A ...
Formatting dates
Help! I need to do a vlook-up between two workbooks with the date being the common between the two. The problem is that the date is formatted in a ...
Selecting columns in excel
Hello, I tried to select a range of cells in excel 2010, using Range("A:H").Select But this selects the whole worksheet. I have tried different w...
Outlook is not responding to in/out mails
Hello, am using official domain.com mail with outlook but all my mails are not going out neither am i receiving mails. can anyone help me on this ...
Outlook 2007 does not send all emails
Hello, Outlook 2007 does not send all emails in the outbox. I reset send/receive to send and receive every 5 minutes on and offline; it did not work....
How to convert number to word
Hello, ow to fix it in excel always. I get it result only when apply it. but can not fixed. please how can I fixed (Permanently Save) in my computer...
"remove duplicates" macro gives error on protected worksheet
Hello, Configuration: Windows 7 / Firefox 19.0 I have a macro that sorts and removes duplicates from a fixed selection in a single column. ...
Animated ppt templates
SolvedHello, can you tel me the website of animated ppt templates???plzzz Configuration: Windows XP / Opera 9.80
Macro: copy row to another header or sheet from a drop down
Hello, I am creating a spreadsheet which contains a drop down list of categories. I am looking for a solution so when a category is selected it wi...
How to compare data in multiple columns
Hello, I have the below data in four columns 14 25 36 214 14 785 114 2563 I have to find out if any two value from the c...
Changes on a pdf document
SolvedGood morning Please can you advise how to make changes on a PDF document that was send to you via email need to change some text
If function with dates
SolvedHello, I'm trying to compare cells with dates. For example: column A column B column C Mar-25 Apr-3 ? In column C I need a...
Pop up message stating empty cells
Solved/ClosedHello, I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there ...
Getting and error msg "the file you are trying to open "xxx.xls"
Hi folks, getting and error msg "The file you are trying to open "xxxxx.xls" is in a differernt format than specified by the file extension. Verify...
Help set up my browser
Hello, Is my bowser set up.with this yet? I want to start my blogging Job,please help. I have a Visual Land tablet.If that will help. Config...
Dates change when copying...
SolvedHello, Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since ...
Need a macro which copy values from rows and paste into a table
Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...
Copy row based on value of cell, and update row data back
Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...
I would like to compare 2 columns.
SolvedHello, I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Colum...
How to do an automation for copy paste, added new row (macro)
SolvedHello, I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 201...
Kindly request for excel help in cell formating
Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...
Formula help needed
SolvedHello, I am in need of a formula. I own a business in which I receive payments from my clients in various ways. I also have multiple locations...
Updating multiple sheets from a master sheet
Hello, Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and ther...
Dj setup
Hello, I want to buy SVM-1000 / 2xDVJ-1000 setup Do you have this ? and 220V ? Your addres plz . Thanks Configuration: Windows 7 / Chro...
Entering value for column at once, displaying in all sheets
SolvedHello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...
Import files into excell 2003 from path
Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path t...
Help combining worksheets in excel 2007
Solved/ClosedWe use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...
Conditional formatting
SolvedHello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...
Use of formula
Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0
Inventory
SolvedHello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...
Vba how to create new worksheet and move value
SolvedHello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...
Have to update data from one sheet to other sheet automatically
Hello, I have four excel sheets , in which some field names are similar. When i update a common field in one sheet i want other sheets to update ...
Format range of cells based off another range of cells
Hello, I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in co...
Excel, if / then or is there a better way?
Hello, I have a spreadsheet that lists each kid in my class. I have entered the answer they gave for each and every question on a 40 quesiton test....
Project 2007
Hello, I have just downloaded project 2007 from this site but I need a product key to activate it. Can anybody help me with this? TNX, Tekii...
Password macro help
Hello, I have a code that unlocks sheets I need to use that are password protected but I have other code I used to combine the worksheets into 1 w...
Vb how execute code for each file open & open multiple files
Hello, The top half is code for opening my file. I tried opening multiple which seems to open but not execute the code I want ran for each file. I'm...
Copying and pasting images without the white background
Hello, i have microsoft excell and im trying to coppy and paste an image from the internet my picture folder but i copy to excell first then save...
Facing difficulties in implementing charts
I have file1, file2, file3 and I want to have a chart with each's G column from 2 to final and each's I column from 2 to final. G in X axes and I i...
Excel macro
Hello, I need a help in using the excel macro I have designed the Userform for searching the particular value from the excel.By typing the valu...
Compare two columns in different sheet and retrive corrspo value
Hello, How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column...
