A Microsoft Office (Excel, Word) forum. 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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
Help - external data by
I have a problem with external data. In the Data Range Properties, under Data Layout. There are 3 options after 'If the number of rows in the data range...
April 11th, 2005 08:52 PM
by Go to last post
0 119
Excel 0 and Blank fields. by
I am working on a spreadsheet that is relatively simple, but I need to have empty cells and cells input with a 0 to give a referenced cell different values. I...
March 8th, 2006 05:16 PM
by ewan7279 Go to last post
2 87
Macro to delete a group of CELLS by
I am trying to get a macro to delete a group of cells as I parse down through the block of instrument data, to weed out blanks or corrupt data. I just want...
May 8th, 2006 04:29 PM
by Go to last post
4 189
how can I split one cell's data into two cells? by
I am using Excel as a database, and have a column with cells with a person's name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have...
May 14th, 2006 10:54 PM
by Ragdyer Go to last post
2 120
Updating Linked Data in Excel by
Does anyone know the best approach for this? I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional spreadsheets which have ODBC links to various...
July 5th, 2006 09:02 PM
by Go to last post
0 91
Simplifying my previous Request for Assistance by
I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information...
July 6th, 2006 02:01 PM
by Go to last post
2 78
Running Macros by
I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function...
July 6th, 2006 04:21 PM
by JLatham Go to last post
1 85
Problems saving a worksheet with links by
Does anyone know how I can resolve this issue ... I have a directory which contains 129 worksheets which have links to external data (in a Master Spreadsheet)...
July 7th, 2006 04:49 PM
by Dave Peterson Go to last post
1 83
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? by
I'm not certain if this one belongs in the EXCEL or ACCESS Newgroup ... ==================================== I have an Aggregate Transfer Spreadsheet Macro...
July 12th, 2006 10:08 PM
by Go to last post
0 105
Excel 0 and Blank fields. by
I am working on a spreadsheet that is relatively simple, but I need to have empty cells and cells input with a 0 to give a referenced cell different values. I...
March 8th, 2006 05:29 PM
by coatej Go to last post
2 82
Relative cells in macro - and pasting a formula too! by
Hi all Thanks for reading this. I'm new to macros, so be gentle with me! I have recorded a macro to import a file and run a couple of jobs on it. When I look...
February 23rd, 2006 03:46 PM
by Bernie Deitrick Go to last post
3 119
Drop Down Boxes in Excel by
How do you set up a drop down box in Excel???
April 15th, 2005 01:33 PM
by Debra Dalgleish Go to last post
2 93
May 4th, 2005 04:28 PM
by CyberTaz Go to last post
1 82
how do I paste an excel column into one cell...tia sal by
Greetings All, I have a column of about 30 values. I would like to paste all these values into one cell. I tried Edit -Paste Special and choose "value" and...
June 8th, 2005 03:27 PM
by sal Go to last post
2 105
numeric sort on one sheet, automatically sorts alphabetical on another? by
How can I set up a sheet where I would input a list of names and numbers sorted numerically, and have that data automatically placed in alphabetical order on...
January 1st, 2006 06:57 PM
by Go to last post
2 192
"Show Placeholders" in options/view menu does'nt work. by
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The...
January 5th, 2006 01:51 AM
by Go to last post
0 62
"Show Placeholders" in options/view menu does'nt work. by
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The...
January 5th, 2006 01:51 AM
by Go to last post
0 91
"Show Placeholder" feature in options/view doesnt work by
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The...
January 6th, 2006 03:43 AM
by Go to last post
0 107
Rounding Question by
Does anyone know if the format function ("Format/Number with x number of decimal places) happens to conform with ASTM E29 for the last...
February 3rd, 2006 02:42 PM
by Bernard Liengme Go to last post
4 87
Missing Password in DSN File by
Hi, I've recently upgraded from Excel 97 to Excel 2003 and am now having a few teething problems with my old DSN files. It seems that Excel 2003 no longer...
January 6th, 2007 04:37 PM
by Go to last post
3 82
Post New Thread


Display Options
Showing threads 121 to 140 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.