Editing multiple cells with one action????

I have created many IF statements running down the page.  To fill dow
the page I added $ to the cell that I wanted to remain constant but no
I want to fil across so I have to change the $ to a different cel
reference in the IF statement.

To avoid changing each individual IF statement (there are quite a few
I was wondering if there was a way I could highlight all of the cell
and just make the change in one which will change all of th
highlighted cells.

Please help, thanks. = 

--
Pedro
-----------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=47810

0
10/21/2005 1:38:01 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
277 Views

Similar Articles

[PageSpeed] 2

It appears that you would put the cursor on the first cell with the formula
and use "Find and Replace".

"Pedros" wrote:

> 
> I have created many IF statements running down the page.  To fill down
> the page I added $ to the cell that I wanted to remain constant but now
> I want to fil across so I have to change the $ to a different cell
> reference in the IF statement.
> 
> To avoid changing each individual IF statement (there are quite a few)
> I was wondering if there was a way I could highlight all of the cells
> and just make the change in one which will change all of the
> highlighted cells.
> 
> Please help, thanks. = )
> 
> 
> -- 
> Pedros
> ------------------------------------------------------------------------
> Pedros's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28202
> View this thread: http://www.excelforum.com/showthread.php?threadid=478107
> 
> 
0
10/21/2005 2:36:01 AM
Reply:

Similar Artilces:

How to convert numbered cells into blank
Hi I would like to know how do i convert a blank cell to a 'completely' blank cell. The blank cell is generated under the IF logic (under the " "); but though we see in as a blank cell it is not completely blank. I need it to be completely blank so I can plot the graph as non continous, rather than registering as zero. Thanks for your help in advance. Maybe this: http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=209 About 2/3 of the way down the page, look for Gaps in Chart Series; Blanks Chart as Zero -- Ryan--- If this information was helpful...

Macro to shade row of searched cell
OK I've looked all over for this but couldn't find it anywhere. I wan to make a macro that searches for a particular value (that would b contained in a cell but not necessarily the only value in the cell) an highlight the corresponding row and not just the cell. I have a macr that searches for a value and highlights the cell containing part o the entire value but I need the entire row shaded. Here's the cel macro. Sub Finder() On Error Resume Next Dim sh As Worksheet Dim rng As Range x = InputBox("Enter Search Term", "Search") Application.ScreenUpdating = F...

COUNTIF Multiple Conditions
How do I use countif with multiple conditions Column B has dates Column C has Various data or Blank I need to count the number of non blanks in column C if column A is one of 3 dates I have tried the array formula below, but am getting the wrong answer {=SUM((Sheet1!$B$2:$B$100=A6)*(Sheet1!$B$2:$B$100=A7)*(Sheet1!$B$2:$B$100=A8)*(Sheet1!$C$2:$C$100<>""))} A6, A7 and A8 are the cells witth the dates in -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getin...

How do I determine row number of a cell containing a certain number?
I have a spreadsheet in which some of the entries in column A contain integers starting with 1 and increasing by 1 until a maximum value (never more than 50). In between, the A cells are blank, even though their rows contain data in the other columns. The number of rows between those with entries in column A is variable. For example, entries might be: A5=1, A9=2, A11=3, A17=4. So there are three blank rows between A5 and A9, one between A9 and A11, and five between A11 and A17. The problem is to determine the number of the row that has the highest number in column A. In my spreadsheet,...

Linking cell in Excel to Folder in Outlook 2000
I have a contact list in Outlook that I wish to link to from Excel 2000 D:\MSOFFICE\OFFICE\OUTLOOK.EXE /select outlook:173 works perfectly from the RUN command. However, using the Hyperlink command in cell formatting does not. My wife runs a parking lot and needs to be able to click on a parking space, say 201 in Excel and have the clients contact information come up from Outlook. In this case the folder 173 contains all the information on a block of contacts 173 to 210. 173 is by default a .xnt file but Excel doesn't by default appear to be able to deal with one. Any ideas ? I obvio...

Lock and Unlock multiple tabs at once
How can I lock and unlock multiple tabs at once. This workbook contains 100 tabs. I will be nice to lock and unlock all the tabs at once without having to go thru the tabs individually ab., you can use a macro like this Sub Protect_All_Sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect Next ws End Sub Paul B "ab" <abensouda@yahoo.com> wrote in message news:C472F3F4-AAA0-4B14-94BA-B8239CC67AA9@microsoft.com... > How can I lock and unlock multiple tabs at once. This workbook contains > 100 tabs. I will be nice to lock and u...

Search multiple IMAP Foulder
I have various IMAP Accounts in WLM. All mails are downloaded completely. Is there a way to search all accounts at the same time? Something external on my desktop ? Thanks for your help ! Stephan ...

Enable the option multiple remit-to address feature in MGP 9.0
Please enable the option multiple remit-to address feature that is available in MGP 9.0. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=665e97a6-6111-46f5-b7dc-a79645d4552...

Link cell to axis maximum and mininum
Hi I have a big number of charts that I would like to change the X-axis maximun and minimum values in an easy way. It would be perfect just to asign e.g. the maximum value to a worksheet cell. Is it possible in any other way to change the chart axis max and min value for more than one chart at a time Best Regard Peter Hi have a look at the following site for an add-in that will achieve this http://www.tushar-mehta.com/excel/software/autochart/index.html -- Regards Frank Kabel Frankfurt, Germany Peter wrote: > Hi, > > I have a big number of charts that I would like to change the...

Show two value ranges on one axis
How do you show two value ranges of the same data on one axis? (the axis range is separated by a zigzag/heartbeat style line). e.g. instead of showing 0-50, the axis could show 10-25 and 40-45. Any help appreciated! Take a look at Jon Peltier's Broken Y axis example. http://www.peltiertech.com/Excel/Charts/BrokenYAxis.html "NOKIA" <NOKIA@discussions.microsoft.com> wrote in message news:2564B7F7-0693-4A7E-A5C8-9D3180B4EA6B@microsoft.com... > How do you show two value ranges of the same data on one axis? (the axis > range is separated by a zigzag/heartbeat style l...

Having Formatting Remain on "Called" cell using IF function
I'm using an IF function to call some other cells, but I want to have the various words color coded, eg ("Certified" is green, "Recertify" is yellow, and "Not Certified" is red). I have the IF function working correctly, but when it "calls" the cell to have it display the appropriate word, the color of each word is not brought along with it...only the text. Is there a way to be able to color code it so that the appropriate color appears? Thanks! -- Zaraf ------------------------------------------------------------------------ Zaraf's Profi...

Save multiple attachments
I use OL2007 and I often receieve mails with multiple attachements. Under the Save as option there have been a choice to save attached files but this option is gone. How do I reinstall it. Kindly Mariah it's now under Other Actions. "MN" wrote: > I use OL2007 and I often receieve mails with multiple attachements. > Under the Save as option there have been a choice to save attached files > but this option is gone. How do I reinstall it. > > Kindly > > Mariah Can you guide me? "dlw" <dlw@discussions.microsoft.com&...

OL2007
Running OL2007 SP2 under Vista Home Premium SP2. It appears that when I'm replying to a plain text message, editing functions (bold, underline, etc) are disabled. Is there a way to enable them? You'd need to switch to HTML format - plain text is, well, plain text. That means no formatting. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchan...

Send the Document, may differ some place due to cell contents...
I think subject wasn't so good that tell you what i wanted to do... I have a text that is about an a4 page in Word. I have an Database of about 150 firms. And two colums; Company name & Company Productivety. Company name Producktivety a 90 b 50 ... .. ... .. And so goes. And the text is like; -------------------------- .................................................. ............ .. ......... Company name: a Company productivety: 90 -...

Multiple Sites for a Contract issue
We have customer who has a Main Headquarters site, and then a number of addresses with one or more items of equipment. Each item is serialised and would be returned for repair if it was faulted. A unit would either be sent in exchange or loaned until repaired and if exchanged then the exchange unit would become the sites contract equipment. At present I can’t see how you can do this, as a contract only seems to accommodate one address and an invoicing address. How can you change the Location address against a Contract Line Item once the Contract has been invoiced and is read only ? Is ...

multiple calendar resources
Hi all New to project, so advice would be welcome. Looking at setting up a new system for project management. Requirements as follows: 1 project manager creating / scheduling installation projects. 10 engineers (resources?). When creating a new project is there a way of automatically checking engineer calendars to see if they are available from within project (so that we don't have to manually check calendars), and we will need to publish and / or update project tasks, as they are created or modified, to the engineers calendars automatically. What setup would we nee...

Copy/Paste cells containing only numbers with .50 in it
I have been trying to come up with a formula that will read each cell in a column and copy & paste only the cells that contain numbers with .50. I can seem to properly configure the formula to read any whole number as long as it contains .50 in it. I want these vnumbers pasted into a seperate column. =IF(D21="*"+"0.50"),(D21),("") Thank you very much for your assistance. =3DIF(D21-INT(D21)=3D0.5,D21,"") If you truly want the numbers copied and pasted you would have to use = VBA. Gord Dibben MS Excel MVP On Wed, 2 Jun ...

Using a cell to determine a value in a database query.
Hi folks, I've run into a problem recently - maybe there's no good answer, then again perhaps you can help me come to one. I have a spreadsheet on which There are three entry fields: start date end date store number I've managed to map start date to [startdate] in a query and end date to [enddate] - that seems to work fine. The problem I'm running into now has to do with the store number field. In the database, store number is a 4 character field, as of now the numbers of the store are like 01,02,03,04..HQ,RO. When I try to map store number to [storenum] in the query, I ...

OWA rule with multiple words
If I make a rule in OWA with one word (for example "viagra") in subject this works fine. But how do I make a rule that includes several words in the same rule, based on the subject ? For example "if there exists words viagra, penis or sex in the subject, then do..." ...

Paste Special drops cells from Word and Excell
Our church is using Publisher 2003 to do our bulletin and newsletter. When we try and use Paste Special to paste the calendar from Word 2003, it drops the last row of cells bottom of calendar (they do not show up in Publisher). If we go back to Word 2003, new document, and paste, everything is there. The same thing happens when we try to Paste Special from Excel 2003. It drops the last column of the Excel sheet. Any suggestions on how to fix this? The calendar and Excel sheet are put together by another individual ( not the secretary) and emailed to the church office. The secre...

space between lines to be one
Re: Outlook 2003 I use Outlook to process my e-mail. How would I make the space between lines to be one (1)? Sometimes the space between lines is two (2), especially between paragraphs. Thank you, Barry Karas "Barry Karas" <barrykaras1234@comcast.net> wrote in message news:EZidnXsnw4464xHbnZ2dnUVZ_rqhnZ2d@comcast.com... > Re: Outlook 2003 > > I use Outlook to process my e-mail. How would I make the space between > lines to be one (1)? > > Sometimes the space between lines is two (2), especially between > paragraphs. > > Thank you, > >...

Are you documenting all your business processes repeatable actions??
Join us for a Free Webinar on: Relevante Solution - The Business Process Recorder (BPR) Date: July 13th 2011 (12:30 PM - 1:00 PM) Overview: Business Processes are the repeatable actions that employees execute daily: contacting customers, ordering supplies, creating invoices. Processes are the building blocks of a company, but surprisingly most companies don't write them down. In fact only 7% of companies document their business processes. Why? Well, documenting process processes takes a lot of time. A new Relevante Solution, The Business Process Recorder (BPR), solves this problem. BPR...

How can I open Posted and Open transactions in one single SmartLis
I want to replace the Sales Transaction SmartList with my own because when we use Extender fields, the Sales Transaction SL becomes way TOO slow. I am able to create faster SmartLists through SQL Views, however, I can only have one type of document status opened in one single SmartList: Open (Sales Transaction Entry window) or Posted (Sales Transaction Inquiry Zoom). The Sales Transactions SmartList allows to open both types from the same list. My users liked the faster SmartLists, but they didnt like that they need to lookup in 2 SmartLists when they don't know if something is open...

Help with cell totals
Hi all, My problem is that I have two rows, one contains the manufacturers name, and the other the amount that manufacturer supplies. What I need to do is get the sum of the amount supplies for each manufacturer. Example: Company 1 8 Company 2 5 Company 2 7 Company 1 2 Totals: Company 1 10 Company 2 12 -- blackie ------------------------------------------------------------------------ blackie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15223 View this thread: http://www.excelforum.com/showthread.php?thre...

how to edit Adobe file
how to edit Adobe file Most certainly not in Word. pdf files, I'm assuming that is what you mean by 'Adobe files', are 'fixed' files. Their layout is frozen so they look the same on any machine and can not be edited. If you still want to edit such a pdf file, you will have to convert the file to something else, edit it, and then save the result back as a pdf. The best tool to do the conversion of pdf files to Word documents is probably Acrobat Professional. Unfortunately, that is a rather expensive product to use for a few simple conversions. There are ...