The discussions
Request for a formula marks of my students
SolvedHello, sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from ...
I cant open my exel .slxs files
SolvedHello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
Enter time by clicking on a cell
SolvedHello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
Conditionally insert a duplicate row
SolvedI have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...
Macro help copy specific text from one cell into another
SolvedHere is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...
Excel - create a bulleted list in a single cell from a list
SolvedHello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...
Why i cant open my pdf files even though i'm having adobe reader
Solved/Closedhai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...
Adding 1 to an existing number if criteria is matched?
SolvedIn column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...
Find the sum of data that has multiple conditions in excel
SolvedHello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...
Error when creating mailmessage
SolvedHello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...
From excel, open a word document and goto a page question
SolvedHello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
Max value in one coulmn based upon another column
SolvedBatch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...
Highlighti row/ colour fill through vb
SolvedHello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...
Comparing data in excel
SolvedHello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...
Re: make a macro run when data entered in a cell -multiple event
SolvedHello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...
Conditional format
SolvedDear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
Look at column and match and add this text te
Solved/ClosedHello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...
Convertion number into word
SolvedSir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...
40 % add formula in excel cell
Solvedi want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...
Insert row data into every second row
SolvedHi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...
Macro
SolvedSub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
Incoming and outgoing mail servers
Solved/ClosedHello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...
Greater than/less than between 2 dates
Solvedi am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...
Macro to highlight cells.
SolvedI am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...
Date change with column paste
Solved/ClosedHello, Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just...
Help me with formulas please?
SolvedHi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...
Creating an if function using dates
SolvedHello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...
Outlook 2007 using windows 7 home premium os ...
SolvedHello, I've not been able to SEND e-mails, only receive them. Outlook 2007 continues to try to send an item from the 'outbox' to no avail; then iss...
Unable to copy selected cells after apply autofilter function
SolvedDear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...
Num convert to text in excel 2007
SolvedR/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...
How to conver image to pdf file?
Solved/ClosedHello, I want to send a File to my friend which in format of Images but Images are so large and my friend want it only the format of PDF File as h...
Vba code 2 import many cells not in range from many workbooks
SolvedHello, I have used some of your codes for importing data ranges from several workbooks. I am using Excel 2010. I have around 2,000 workbooks ...
Formula help
SolvedHello, I think this is a simple question just not for me :) I have a simple business spreadsheet showing total project cost in Column (C.) C, T...
Formula not working
SolvedHello, Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"...
Import from multiple workbook to single sheet
SolvedHi, Thank for all your wonderfull help all these days, to cut short, I am looking for a VBAcode, which can import data from multiple Workbook file...
Comparing two columns of names in excel
Solved/ClosedHello, I have one excel sheet. column A has a list of names formated as follows: Last name, First name Column B has a much longer list o nam...
Spreadsheet data
SolvedHi everybody. I am trying to develop a large data input spreadsheet which will have circa 20 operators data input on a daily basis. (approx 150 ent...
Attendance sheet
SolvedHi, i want to make attendance sheet in Microsoft Excel 2007 with alphabetical words like P for Present, A for Absent, L for Late, H for Holiday wit...
Excel vba to open other screen
Solved/ClosedHello, We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application...
How do i get excel file ( no formula) from another one ( with fo
SolvedHello, I have a big excel file with lots of formula and link. now can I export these data only( no link or formula) to another excel file? Thank yo...
How to check two fields in excel and act by that?
SolvedHello, Can anybody help? I would need very simple macro to check two cells. A1 will be name A2 A3 will be second namew A4 Does A2=A4 ...
Conditional formatting
SolvedI am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of...
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 ...
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...
Animated ppt templates
SolvedHello, can you tel me the website of animated ppt templates???plzzz Configuration: Windows XP / Opera 9.80
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 ...
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 ...
