Text to Columns
Hi. I have a column where I have names and surnames. I want to put name in one column and surname in anoter column. In order to do this, I use Text to Columns, but I have the following issue: if the cell contains for example Juan Pérez, it works ok, but when the cell contains Juan De los Santos, it assumes t... 2 Jun 2010 14:17
Hidding rows when sorting
Hi all I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and hides the one which does not match. Is there an event I can catch so I can hide even more? It is a file someone else made at some time, so: how do I add... 1 Jun 2010 18:39
Grouping Time in Pivots.
I have a large DB, this is a small example, Client Date Time 1 5/31/2010 9:32:43 AM 1 5/31/2010 9:34:21 AM 1 5/31/2010 10:51:39 AM 3 5/31/2010 11:10:13 PM 3 5/31/2010 03:13:10 PM 5 5/31/2010 05:42:01 PM 5 5/31/2010 06:45:43 PM 2 5/31/2010 06:47:11 PM 4 5/31/2010 08:50:31 PM I would like to create a pivot... 1 Jun 2010 15:19
"Save file before closing"
Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from Windows Explorer, right click and select Print. It would open an Excel file, print it, close it and repeat for the next file. I could go home for the evening, and the hard copies would be on my printer when I came in the next mornin... 1 Jun 2010 15:19
Matching 2 spreadsheets9tabs) in 1 excel s/s
hi, Does any one know what formula (ie: Index Match) to match at least 2-3 fields on 2 spreadsheets(data obtained from 2 systems)? If there are any empty columns in any of the spreadsheet, do we have to remove them in order for the formula to work? ... 1 Jun 2010 11:59
Unable to access hyperlinked files.
We have a training matrix which is an excel spreadsheet. Each training record is hyperlinked to the appropriate cell on the spreadsheet for each department member. This recently underwent a major overhaul. The existing spreadsheet was copied to another network location. Changes were made adding and removing... 1 Jun 2010 10:52
copied additional column shows in view but does show on hardcopy
I have an existing spreadsheet and needed to add another column with the same format. I copied it and but when I print a hard copy it is not there. I checked and that column is not hidden. ... 1 Jun 2010 10:52
Excell 2003 Linking Pages
I use Microsoft Excel 2003 to track daily sales for both the my store and employees. I also track the sales on a monthly basis and prepare an end of the year report. I use a separate workbook for each report. I would like to know if it is possible to link the totals from each report into one workbook or works... 1 Jun 2010 13:06
Insert option icon
Hi all! How do I get that annoying paint brush icon to stop appearing when I insert a blank row in a series of data? I am using excel 2003. Thanks! Amy ... 1 Jun 2010 09:46
If statement in excel
Glad it's working for you- I've had lots of help on here learning VBA so I'm more than happy to put something back. Cheers, John --- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/If-statement-in-excel ... 1 Jun 2010 08:39