General Discussion - Page 108 - OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
copy 1 column from another spreadsheet by GRS I have a three files that i export to regularly, the columns and titles are always exactly the same but the actual data in them changes each time I export. ...	August 2nd, 2004 07:14 PM by GRS	2	326
Floating numbers to a specific cell? by joec Is it possible to have a cell, let's say row 1 column Q to reflect the last cell of column R. Example: Column R row 5 on day 1 is 35, then on day 2 row 6 is...	August 2nd, 2004 07:23 PM by b&s	2	422
Copy, Paste special (Value) Very slow by Yanick I am experiencing something strange. I often have to VLOOKUP on worksheets containing around 10 000 rows. VLOOKUP work well but after that, when I try to do a...	August 2nd, 2004 07:33 PM by Yanick	2	551
Can data validation also autocomplete? by Vato Loco I want to know if you can have the entry cell autocomplete when it has a drop down bx. Is this possible? Thanks, Vato --- Message posted from...	August 2nd, 2004 07:43 PM by Bernie Deitrick	3	227
unhide rows adn columns by how can i unhide rows and columns. this doenst work: Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance	August 2nd, 2004 07:58 PM by Nick Hodge	3	447
Changing -> File, properties, Summary (A Repost) by Hari Hi, As mentioned in the subject please note this is a repost. I tried the solution given by Bob P but couldnt get it to work.( I might have misinterpreted...	August 2nd, 2004 08:04 PM by Bob Phillips	6	453
Excel Pivot Table - Calculated Items Problem by BobsySpud I have created a Pivot table with the following fields: Customer; Product; Actual; Budget; Variance where 'Variance' is a calculated Item within field name...	August 2nd, 2004 08:47 PM by Debra Dalgleish	1	349
Move data in a column when the date above changes by 2000watts I have created a very simple schedule for my employee's with the projects listed to the left in one column, each column to the right has employee's listed...	August 2nd, 2004 09:25 PM by Frank Kabel	1	257
date to day of week ignoring blank cells by emm8080 Hi How can I covert dates to days of week eg 30/07/04 = Fri without converting blank cells at the end of the column. Obviously, I can specify the column...	August 2nd, 2004 10:24 PM by Dave Peterson	8	317
Excel VBA - Highest Value and Second Highest Value by Parlatoc I'm working in Excel 2003, and have run into an issue I'm not sure there is a solution. If there is I don't know. I have a several responces for 15k+...	August 2nd, 2004 10:44 PM by Frank Kabel	1	322
Margin Setting by plumstone I have a workbook with 21 worksheet. How can I have the same margin setting for all the worksheets? Thanks in advance.	August 2nd, 2004 10:45 PM by Frank Kabel	2	155
Problem with recent Drop Down List Code by krislyn I recently got this code from Bob and just today tested the check boxes. Problem is when I try to check any box beyond the first column, it will automatically...	August 2nd, 2004 11:10 PM by Dave Peterson	1	465
Lookup - Formatting of numbers by GRS I currently have a lookup field in my spreadsheet that looks up the price of a product by product number. Although the lookup usually works there are...	August 2nd, 2004 11:31 PM by Dave Peterson	6	375
extracting info from multiple sheets by Jacob I have seven sheets same setup for all seven sheets. It is a bank register, each sheet is for a diffrent bank. I would like to get info filtered from all...	August 2nd, 2004 11:40 PM by Dave Peterson	3	414
pasting column and row width and heights by Pasting column width and row heights When I copy data where the column width and the row heights have been changed why doesn't it keep the column width and row heights?	August 2nd, 2004 11:42 PM by Dave Peterson	2	286
What does the [Group] in a file name mean? by EES I have worked with 2 to 3 Excel files that have the designation of "" in them. Does anybody know what the relevance of this and if it is known to cause...	August 3rd, 2004 12:00 AM by JE McGimpsey	3	136
timesheet formula by David I've set up a bi-weekly timesheet in XL2K for a two-week pay period. D4:D17 contains the calculated time worked each day Overtime is paid for hours worked...	August 3rd, 2004 12:52 AM by David	2	388
statistical analysis by silvia restrepo I am trying to do a correlation analysis but I have missing data, how can I deal with this, is there a way of coding missing data like a . in SAS?	August 3rd, 2004 01:48 AM by Jerry W. Lewis	1	275
Use VBA to format cells by emea training 2 Is it possible to use a macro to format Excel? I have a number of sets of data under headings e.g. Heading1 Data 1 Data 2 Data 3 Data 1 Data 2 Data... ( 1 2)	August 3rd, 2004 02:02 AM by Dave Peterson	11	331
Help to add Format to VBA Code! by Bob -- After searching Google.groups.com and finding no answer, Bob Vance asked: Can "CopyFormat" be added to this code Sub MonthPlus() With... ( 1 2)	August 3rd, 2004 02:07 AM by Dave Peterson	10	274

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed