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 Last Post Reverse Sort Order Replies Views
Use Macro to Copy and paste formulas from one spreadsheet to anoth by bevchapman
I am trying to copy and paste a block of cells from one spreadsheet to another. The original file is formulas and the destination cells must be the same...
October 6th, 2009 05:50 PM
by Jacob Skaria Go to last post
3 120
Help goes to IExplorer by Garich
Using Vista & Office 2007 I get a couple 'normal' help screens until I get down to a specific help. At that point, a pop-up box titled "File Download" asks...
October 6th, 2009 05:44 PM
by Garich Go to last post
0 128
Formula help by Confusicous
d1= ln(B6/B7)+ / (B9) (SQRT B10) This is supposed to be Black-Scholes Option Pricing Model. I tried my best to show the formula on here and I entered the...
October 6th, 2009 05:42 PM
by David Biddulph Go to last post
4 185
Link to Named Range in External File by Jason
Hi, I have to workbooks, workbook1 and workbook2. I have a named range in workbook2. In workbook1 I used the get external data feature to link to the named...
October 6th, 2009 05:42 PM
by Jason Go to last post
0 105
Delete 1 row of objects, not all on sheet Excel 2007 by Paula
I know how to remove all objects on sheet, and 1 at a time. But I only want to delete 1 row of objects on the worksheet, not all of them. There are many in...
(Multi-page thread 1 2)
October 6th, 2009 05:40 PM
by Bob I Go to last post
11 164
Conditional formatting icon sets - creating a legend? by dbagby
Does anyone know of a way to create a legend for the icon sets to identify what they represent? I am using the Icon Set Style 3 signs and I would like a...
October 6th, 2009 05:17 PM
by dbagby Go to last post
0 122
Linking Formulae Across a Workbook by Mikki Shaw
I have created a workbook in Excel 2003, there are lots of worksheets within this workbook. Basically I am trying to monitor an accumulative balance. My...
October 6th, 2009 04:49 PM
by Mikki Shaw Go to last post
2 102
displaying specific rows on screen by johnsail
Hi I would like to control which lines are displayed on screen. For example:- when user gets down to line 35 I would like to display form line 20 onwards....
October 6th, 2009 04:43 PM
by Jim Thomlinson Go to last post
1 94
Conditional Formatting Tab Locked by WOODY
Hi All I have formatted a spreadsheet I use daily using the conditional formatting options and for some reason the tab is now greyed out so I can't get back...
October 6th, 2009 04:36 PM
by Gord Dibben Go to last post
2 121
macro deletes wrong columns by Wanna Learn
Hello I have excel 2003 . Every day I receive a file and I have to delete some columns. so I created a simple macro to delete the columns I do not need. ...
October 6th, 2009 04:34 PM
by Jim Thomlinson Go to last post
4 103
Bypass Auto-Open Procedure by QB
How can I bypass the auto_open procedure when I open a workbook? Previously, holding down the SHIFT key worked beautifully (2003 and prior). However, with...
October 6th, 2009 04:29 PM
by Bob I Go to last post
1 128
Delete the clipboard icon in Excel 2007? by Option Trader
How do I delete the clipboard icon in excel 2007. It follows me on the worksheet whenever aI do a cut and paste. It is in the way an annoying.
October 6th, 2009 04:25 PM
by Option Trader Go to last post
0 95
overwritten files by roseprince
i recently received an excel spreadsheet with an identical name to a newer one i've been using and inadverdantly saved the older version over the new one. is...
October 6th, 2009 04:23 PM
by David Biddulph Go to last post
1 126
Make a word out of two cells by Wombat
I have two columns of cells: one with a 3 digit number and the other with a name. How do I put the two together in a column so that it looks something like...
October 6th, 2009 04:23 PM
by Eduardo Go to last post
3 96
Linking cells with changing format by Wombat
Hello people I was wondering if its possible to copy a cell (from one tab of a document to another) and have them linked so that the format will change in...
October 6th, 2009 04:08 PM
by Wombat Go to last post
3 130
Bypass a function in a Macro by bevchapman
I am building a Macro that can run on a worksheet training matrix whether if is filtered or not. It works beautifully as long as the file is filtered but...
October 6th, 2009 04:07 PM
by Dave Peterson Go to last post
3 109
Save as before do you want to save by Levi
It's taking me a little time to get used to Office 2007, but one thing that really really annoys me is that when I close a document - even if I don't make...
October 6th, 2009 03:55 PM
by Levi Go to last post
0 103
keeping format of a referenced cell by Valeria
Dear experts, I have a workbook where I reference cells from one worksheet to the other. Ex. Cell A1 of Sheet2: "=Sheet1!A3" My challenge is that I would like...
October 6th, 2009 03:44 PM
by Gord Dibben Go to last post
4 123
Problem with pivot tables overlapping with new data by jjonessnl
I am trying to put 3 pivot tables on one worksheet. The amount of data will vary depending on the criteria I use to filter on. Is there a way to insert...
October 6th, 2009 03:00 PM
by Jim Thomlinson Go to last post
1 136
To find out % of profit by pol[_2_]
Hi all, Please help to write a formula for the following case A1 cell conatin cost value 500 A2 Cell contaain sales value 700 In A3 cell I have to find...
October 6th, 2009 02:48 PM
by Stefi Go to last post
4 100
Post New Thread


Display Options
Showing threads 12161 to 12180 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 12:35 AM.


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