Summary: Hi, Not sure if I am missing the point here, but if you open your existing comma delimited files or Quicken files, make the formatting changes you nee...
Summary: I'm trying to copy cells in SheetA to SheetB but they are split across two or more rows. I need to detect a null (or empty) cell in sheet A and th...
Summary: In this forum, we don't usually answer homework questions directly, since the object is for you to figure how to use Excel to complete the assignment....
Summary: I am pretty new to IF statements in the context of excel and have no idea how to complete the latest one I need. Basically Its like this: The are thre...
Summary: Hi, I need to switch between 2 open excel worksheets and copy data from one to another. I cannot use the file names to say which one I want to switch ...
Summary: I have one user who cannot print emails from one other user. You click print, nothing comes up. Try to go to file>print? Same problem. This only effec...
Summary: Absolutely if you have a professional powerpoint to video converter like Moyea PPT to Video Converter and Leawo PowerPoint to Video.As far as I know,t...
Summary: First change the Windows settings. Control Panel Regional Language and Options Select English United Kingdom Make sure the Short Dates and Long Dates ...
Summary: Well, if you want to go really basic, you could sort both columns next to each other and find the 2 spots where they don't line up. After the first mi...
Summary: Hi, Here it is with email. There are several e-mail settings that you will have to enter yourself, including the name of the SMTP server. You will l...
Summary: Hi I'm creating a workbook to generate invoices, with an "input" worksheet for people to enter data and an "invoice" worksheet which will be protecte...
Summary: thanks for the suggestion, Humar, but it will be hopeless its Eclipsecomputers of Coventry, UK google then and you'll see their reputation ( though th...
Summary: While it's true that you cannot copy and paste from a closed workbook, you can link to it, pull in the data and then Copy/PasteSpecial the values. Jus...
Summary: Our company decided to organize paperless office and introduced electronic document management system DocumentLite.Software tools are used to process,...
Summary: I cannot use Macro that i record before Before I was create new macro in Ms word. Then I close Ms word. When I open Ms word again i cannot use Macro. ...
Summary: Hi, I see that you have entered your times into cells F8 and F10 using this format: 00:00:00 which is: min:sec:hundredths. Excel treats this entry as ...
Summary: I have a user who was using Outlook 2003 on Windows XP SP3. She has some distribution lists (DL) in her Contacts folder with a lot of entries. Most ...
Summary: Hi, If this sorting by date is not done very often then I suggest using Excel's Sort function manually. For sort to work, all the data for each indivi...
Summary: I just converted from Windows Vista to Windows 7. I cannot open e-mail. I keep getting the message "unable to open your default e-mail folders" Whe...
Summary: Hi, I have a solution for this issue. I have tested it on the sample data you provided, plus one extra to cover a transition from Low to High season...
Summary: I have Ubuntu on Linux platform. I cannot open Pagemaker text files. Do you know what program I can download if it is safe, or can I change Pagemaker...
Summary: Hi, Your original sample data indicated that there was a single selection, with alternate rows to be inserted. The code I provided will not work on m...
Summary: Hi, I presume that this is some sort of assignment. As such I won't provide a solution, but I can point out several issues with the formula you poste...