setting print area for multiple worksheets at once

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Offset from refernce in other cell I need to point a cell to another as an offset from a reference. For example, cell A1 formula is =G10 I want cell A2 formula to be =G20 I need this to be dynamic as I need to drag it along the whole spreadsheet. I can't seem to get this to work using the offset or indirect functions. Any ideas? Jonathan Blitz AnyKey Limited Israel Tag: setting print area for multiple worksheets at once Tag: 70007
  - 2
    - 60 GB IPOD deal found I just completed this offer for a 60 gb photo ipod and it is awesome! My friend got one from it and he is waving it in my face and taunting me! Anyways, all you have to do is complete a promotion offer and cancel it before the 30 days trial is up and then get 8 referrals. I recommend doing the rhapsody promotion because it is only $0.99 and you get instant credit towards your ipod. It is so cool. Check it out. http://www.freephotoiPods.com/?r=21360900 Tag: setting print area for multiple worksheets at once Tag: 70006
  - 3
    - Excel 2002 Pivot Table #DIV/0! Keep getting this error message in a percentage data field. The fields that are used are "calculated" data fields and not from the excel list. Tag: setting print area for multiple worksheets at once Tag: 69999
  - 4
    - spelling Am working on a workbook in Excel and trying to check the spelling, i gives the following message: Do u want to continue checking at the begging of the sheet Yes/No I choose Yes, then it gives me the following message The spelling check is complete for the entire sheet But it did not check the spelling, although there are mistakes, what t do? any ideas. Thank u in adv -- Geo ----------------------------------------------------------------------- Geor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2347 View this thread: http://www.excelforum.com/showthread.php?threadid=39781 Tag: setting print area for multiple worksheets at once Tag: 69997
  - 5
    - "locked for editing" Excel XP I was working on a spreadsheet for a friend, and kept getting the "locked for editing" error. The friend is on a standalone PC, and I was saving my copy to the local hard drive. We are both getting this error, even when we create new files from the old one. Neither one of us is working on a network drive, and my friend isn't even on a network. Any ideas how to fix this other than constant rebooting? TIA, Doreen Tag: setting print area for multiple worksheets at once Tag: 69994
  - 6
    - title row Hi I have an excel of about 150 rows the first row is a title when I print the title is on the first page but not the others - can I get it to auto add to each page ? David Tag: setting print area for multiple worksheets at once Tag: 69993
  - 7
    - Countif problem Hi I have an excel and I want to count letters - one of the things I am counting is the number of A* where A* is the actual data. In countif excel is treating the * as a wildcard and is counting As too - I only want it to count "A*" - any ideas ? David Tag: setting print area for multiple worksheets at once Tag: 69990
  - 8
    - Combined Functions Hello, I am trying to streamline my work. I am trying to apply two functions to the same data at once. Is this possible? 1. PROPER(A1) 2. TRIM(A1) How would I combine the above two and have the result appear in one cell? Thanks, -- fncuis ------------------------------------------------------------------------ fncuis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26466 View this thread: http://www.excelforum.com/showthread.php?threadid=397792 Tag: setting print area for multiple worksheets at once Tag: 69987
  - 9
    - What tool to use to customise the look of portal server? Hi all I usually use Front page to create a website / web page. Now I just install Portal Server 2003 and wish to customise the look and feel of the site. It look me ages to manage to have the search works (re-install the system about 5 times!) Now I want to customise the look but I am not sure whether using front page is the way to do as I saw some posts which some people mentioned the malfunctions of the search after using Frontpage to customise their page. My questions are 1. Is this the case? 2. If so what could be the alternative package to use to customise the page in Portal Server? Any recommendations will be much appreciated Thanks Peddie Tag: setting print area for multiple worksheets at once Tag: 69983
  - 10
    - Filesize Hi, I have a spreadsheet that contains lists of data (just data, no external links), over the years of data collection this has reached 96meg, I tried to make the file smaller by saving a copy and deleting current data and calling this copy 'history.xls', I then deleted the historic tabs from the working version and saved it. The problem is that, despite deleting the old data, the file still shows as being 96meg. I am presuming that the data is still in existance 'behind the scenes' how can I update the file without copying the current tabs into a new workbook? Darren Tag: setting print area for multiple worksheets at once Tag: 69982
  - 11
    - 60 GB IPOD deal found I just completed this offer for a 60 gb photo ipod and it is awesome! My friend got one from it and he is waving it in my face and taunting me! Anyways, all you have to do is complete a promotion offer and cancel it before the 30 days trial is up and then get 8 referrals. It is so cool. Check it out. http://www.freephotoiPods.com/?r=21360900 Tag: setting print area for multiple worksheets at once Tag: 69981
  - 12
    - MailMerge Problem This *might* be a Word problem, but I have a feeling its not. Excel XP, Word XP. I'm merging data from Excel into Word. I have cells that have data like: 101, 107, 109, etc and they merge fine. However, when I get to the cells with data like : QB101, QB107, QB109 I get a "0" in the field instead of my data. The column is formatted as text. When I do a =ISTEXT I get a "true" response, yet I still get a "0". Any idea what I'm doing wrong, or what I need to fix/change? Thanks in advance for your help! Doreen Tag: setting print area for multiple worksheets at once Tag: 69980
  - 13
    - Help with a schedule I need some help with a work schedule done in Excel. The schedule is not very complex; however, when multiple changes to the schedule are made for vacations ect, it becomes a garbled mess & I find that some problems arise for me to be able to mentally determine how many people are working during a given time when it's in text format. I think it would be much easier to see in a chart if I was able to convert the text into one. (A page of our current schedule can be downloaded for reference at http://homepage.mac.com/WebObjects/FileSharing.woa/wa/schedule.jpg.jpg-bi nhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/schedule.jpg) If there's a way to do it, I'd like to be able to chart a 24hr period (6am one day to 6am the next day for example) and be able to see who's working during that day with the start of the bars of the chart showing the start time of the person's shift and the end of the bars of the chart showing the stop time of the shift. I don't know if that makes sense. I've tried to give an example of what I mean here: http://homepage.mac.com/WebObjects/FileSharing.woa/wa/24hr_Chart.jpg.jpg- binhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/24hr%20Chart.jpg Any and all help would be appreciated! Thanks! PS: if the above links for the sample files dont work, the sample files can be seen/downloaded here: http://homepage.mac.com/gadgetman/Schedule/FileSharing9.html Tag: setting print area for multiple worksheets at once Tag: 69979
  - 14
    - Open Two Instances of Excel 2K Hi All, I used to be able to open two instances of Excel such that I could look at two workbooks at the same time with dual-monitors running. Anyone know how I can get this kind of setup back? Thanks & Ciao, Tony Tag: setting print area for multiple worksheets at once Tag: 69978
  - 15
    - Excel 2002 Check for duplicates Sorted an Excel list for a Pivot Table by Check number for the years 1997-2005. Any easy way to check for duplicates w/o getting into VBA? Check# 7894 7895 7895 7896 Tag: setting print area for multiple worksheets at once Tag: 69974
  - 16
    - How to change *defaults* for importing Tab-delimited text file into Excel2002 - How to I change the default setting when importing a .txt file? I spend a lot of time converting Excel (Office 2002) files into HTML. The quickest way to clear off all the Microsoft formatting crud seems to be to save as a tab delimited .TXT file. This works well but it is extremely irritating that having saved as "tab delimited text" from Excel, that the same piece of software cant recognise its own file when you reopen it! It seems to default to Delimited and file origin "932: Japanese (Shift-JIS)" whereas what I want is file origin of: "1252 : Western European (Window)". However this requires clicking on the drop-down list (which always takes a while to fill up for some reason) and the scrolling to the bottom of the list...! How can I get Excel to recognise the file-type of what it has just saved?! Ship Tag: setting print area for multiple worksheets at once Tag: 69969
  - 17
    - Help with Lookup formula I have a three columns of data, column A has part number, column B has cost, column C has company name. What I would like to be able to do is for a formula to lookup 'company1' and give me a total cost of the parts. Is this an easy thing to do? Tag: setting print area for multiple worksheets at once Tag: 69965
  - 18
    - Extracting data from pivot tables Hi, I am creating a chart using data from various pivot tables. In order to do this I am creating a data table using data extracted from the data tables upon which I will base my chart. In order to take the data from the pivot table I create a formula by typing = then going to the pivot table cell that I want. So far so good... however, is there a way that I can drag this formula across to pick up the next cell and the next etc (just like if you were doing a formula within excel) rather than having to create a new formula for each cell that I want to pickup? Tag: setting print area for multiple worksheets at once Tag: 69964
  - 19
    - footer Hi, Is it possible that if user creates new documents in word or excel, automatically (date, name, paths and etc) to be added as footer or is it possible somehow to make domainwide via AD? Regards, Ramin Thanks, Ramin Tag: setting print area for multiple worksheets at once Tag: 69958
  - 20
    - IF conditional statements Hi, It's my understanding that I can nest up to seven levels of the IF functions within one formula. My question is how does one nest over seven levels? Below is the actual code without adding the additional IF statements. =IF(D8=" "," ",IF(D8=$L$81 Then +Insured!$G$38-Worksheets!D45,IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,IF(D8=$L$84,+Insured!$G$44-Worksheets!D45))))) Here's is an example of over sevel levels where I like to add to the cell, but again I cannot because Excel only nest up to seven levels. =IF(D8=" "," , IF(D8=$L$81,+Insured!$G$38-Worksheets!D45, IF(D8=$L$82,+Insured!$G$40-Worksheets!D45, IF(D8=$L$83,+Insured!$G$42-Worksheets!D45, IF(D8=$L$84,+Insured!$G$44-Worksheets!D45, IF(D8=$L$85,+Insured!$G$46-Worksheets!D45, IF(D8=$L$86,+Insured!$G$48-Worksheets!D45, IF(D8=$L$87,+Insured!$G$50-Worksheets!D45, IF(D8=$L$88,+Insured!$G$52-Worksheets!D45, IF(D8=$L$89,+Insured!$G$54-Worksheets!D45, IF(D8=$L$90,+Insured!$G$56-Worksheets!D45))))))))))) Any tips will be appreciated. Thank you. Tag: setting print area for multiple worksheets at once Tag: 69955
  - 21
    - Need rows in Column A removed if... Hi There, I have rows of text strings in Column A and in Column B. I need rows in Column A removed if they partially or exactly match with text strings in any Column B row. Your input is appreciated! Alexa Tag: setting print area for multiple worksheets at once Tag: 69950
  - 22
    - Excel: numbers in cells get divided by 100: all spreadsheets ... Hi, I have a strange problem that I don't know how to fix. I'm using Excel 2000. Something happened recently and I'm not sure why or how, but in every spreadsheet I have if one enters a number into a cell the number will be divided by 100 automatically. This happens in all my spreadsheets, so I thought Excel might have been corrupted somehow. I have reloaded Excel, actually "Office 2000", three times now and, also, I tried to delete any files that I thought might be related to Excel (before reloading again) but the problem remains. I've looked and tested all the menu items but I have not come upon a feature that causes the problem (or solves it). Could it be that every Excel file I have has been modified somehow so they all have this problem that I don't know how to get rid of? I'm almost at my wits end with this. I'm using MS Windows Me. Any ideas to help would be greatly appreciated! Al Tag: setting print area for multiple worksheets at once Tag: 69944
  - 23
    - Pivor Table Data Field - "Show aftering Hide" This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have tried to "show" a data field after using "hide" in field = settings. How can I make this reappear? Not using Field drop down = option. The fields orgin is from the excel list and not a calculated = fields. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have tried to "show" a data field = after using=20 "hide" in field settings.  How can I make this reappear?  Not = using=20 Field drop down option.  The fields orgin is from the excel list = and not a=20 calculated fields.</FONT></DIV></BODY></HTML> ------=_NextPart_000_000C_01C5A644.DE8D0D20-- Tag: setting print area for multiple worksheets at once Tag: 69939
  - 24
    - error/please help I formatted my PC & did a clean install of Windows Xp PRO when i opened Excell i get this error message. Microsoft visual basic COMPILE ERROR IN VISUAL MODULE:AUTO EXEC NEWThe help files tell me to unprotect,BUT there is no unprotect option in tools/protection. I uninstalled Excel,bebooted & installed Excell. Still get the error Tag: setting print area for multiple worksheets at once Tag: 69938
  - 25
    - Error please help I formatted my PC & did a clean install of Windows Xp PRO when i opened Excell i get this error message. Microsoft visual basic COMPILE ERROR IN VISUAL MODULE:AUTO EXEC NEWThe help files tell me to unprotect,BUT there is no unprotect option in tools/protection. I uninstalled Excel,bebooted & installed Excell. Still get the error Tag: setting print area for multiple worksheets at once Tag: 69937
- Next
  - 1
    - print pre-printed forms Is the any way to use excel to print pre-printed forms ( invoices , etc ) after all datas are entered? Is there any way to design a template for that ? Tks !! Osvaldo Tag: setting print area for multiple worksheets at once Tag: 69935
  - 2
    - Deleting Sheets Based on Name Ive got a macro which makes a large number of sheets with information in them.... Ive then got another macro which gets all the information from those sheets.... the problem is... im then left with all the sheets.. and I really want to delete them..... Is there anyway to make a macro which would let me delete sheets.. based on their name..... all the ones i want to delete are called "cats (104)" or "cats (105)" etc etc..... there is one called "cats" which i want to keep.... so basically If it could someonie delete based on the term "cats (" any ideas? Tag: setting print area for multiple worksheets at once Tag: 69931
  - 3
    - Max valve for each customer Hello, I am the new member here and would like to seek your prof. help in Excel. Thank you. Given: _A1:_Customer_ A2: JOE A3: TOM A4: JOE A5: PETER A6: JOE _B1:_Purchase_ B2: $11 B3: $22 B4: $25 B5: $20 B6: $11.5 How can I have gotten the max pruchase for _each__ customer? Let's say, Joe have total 3 records in the sheet (A2, A4 & A6) and the purchase are $11 (B2), $25 (B4)& $11.5 (B6) respectively. What I need is to sort out the max purchase value of JOE, i.e. $25. Thanks all! -- syscan ------------------------------------------------------------------------ syscan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26486 View this thread: http://www.excelforum.com/showthread.php?threadid=397545 Tag: setting print area for multiple worksheets at once Tag: 69929
  - 4
    - Help with a formula please. In column "A" I have about 400 file names with each path, for example: D:\Folio_02\AL605_02.xls Each file contains a value named "ATT" and another named "XBB". I need to get these values in adjoining columns. I've tried every variation of the following I can think of without success: A1&"!"&ATT None have worked. I'm sure I have done this before but can't remember and can't find any of my old files with an example. Please help. Jim Tag: setting print area for multiple worksheets at once Tag: 69915
  - 5
    - Viewing Zero's In Cells Hi, I am entering telephone numbers into a spreadsheet, and as these all start with a zero. I enter a ' preceeding the zero, but this still displays a triangle in the top left of the cell. Is there any way I can enter a cell beginning with a zero without the triangle showing? Thanks Greg Matthews Tag: setting print area for multiple worksheets at once Tag: 69909
  - 6
    - Help counting items please Having a bit of trouble counting items on the following example: A B 1 Apples Pears Bananas Green 2 Peaches Apples Grapes Yellow 3 Pears Oranges Tomato Green 4 Corn Squash Apples Green I'd like to use a formula to count how many cells in column A contain "Apples", while at the same time column B contains "Green" I can do a conditional sum to find out how many cells in column A contain "Apples Pears Bananas" and column B "Green", but can anyone tell me how to look for just the one word within a cell, when the word position could be anywhere within the cell, and conditionally sum it with column B? Many thanks in advance! Tag: setting print area for multiple worksheets at once Tag: 69899
  - 7
    - message box? This will be very basic for you guys, I want to create a message box when somebody tries to change any part of my workbook, with some kind of "copyright" notice. I presume I protect the workbook first, then enter some kind of code. Anybody help with this please? Tag: setting print area for multiple worksheets at once Tag: 69896
  - 8
    - Help! I'm completely clueless w/ Excel! Hello -- Please be kind! I'm new to these boards and I'm miserably clueless about Excel. I need some help with my Statistics homework so if you're kind and/or valiant and/or bored enough to hand-hold a complete idiot through the process, I'll be so absolutely grateful! :) Okay, so in this assignment I have a spreadsheet file: Column A has a series of various numbers: A1 has 10; A2 has 30; A3 has 5; ..and on and on it goes. 1) In this assignment, I have to somehow make column B bring out the percentage difference from an arbitrary number (in this case 20) to the numbers in the A column. For instance, since A1 is 10; B1 will have to be -50% (since 10 is a 50% decrease of 20). And for B2, since A2 is 30, B2 should generate a 50% in its cell (since 30 is a 50% increase from 20). So how do I make Excel automatically generate the percentage differences for rest of the B column? 2) So after the B column gets filled out...is there a way for Excel to determine the probability that a certain percentage will occur, judging from what's spat out into the B column? For instance, one of the questions on my assignment asks for the probability that -45% will happen, judging from what's generated in column B... So how I do I input a formula/code for Excel to look through what's in the B column and determine how likely -45% (or any other percentage) happens? I know there're many ways Excel can figure out probabilities -- so if you'd be so kind to just hand-hold me through a basic approach, then mention any other methods that may yield better answers, I can look them up accordingly.) (Please don't be mean! If possible, please try to explain all this as gently and as "step-by-step" as possible -- you know, as if I'm a complete dunce, because, well, I am. :( ) Thank you so much for any help and insight you can provide! :) -- Ayn00 ------------------------------------------------------------------------ Ayn00's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26476 View this thread: http://www.excelforum.com/showthread.php?threadid=397447 Tag: setting print area for multiple worksheets at once Tag: 69895
  - 9
    - Worksheets I have an excel book with several charts. I need to know how I can create a pivot table or VBA formula, that will allow my manager to select a certain BRANCH from a dropdown list and display its corresponding chart? -- tdiaz ------------------------------------------------------------------------ tdiaz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26468 View this thread: http://www.excelforum.com/showthread.php?threadid=397375 Tag: setting print area for multiple worksheets at once Tag: 69880
  - 10
    - Serious printing /cache problem I have an e-mail with an excel report of inventory i've sold. When I choose to open the e-mail (double clicking in outlook) it displays fine but when I print it, it prints a REALLY old version of that document... and I have no clue where it's getting it. The e-mail they send always has the same file name. Yet, even if I save the file to my desktop, open it from there the contents of the file looks just fine, but when I print, it prints some old information from a july version. Please help. Tag: setting print area for multiple worksheets at once Tag: 69876
  - 11
    - how to print the worksheet name somewhere on the printed page ? Hello there I was wondering how to print the worksheet name somewhere on the printed page ? Thanks Tag: setting print area for multiple worksheets at once Tag: 69875
  - 12
    - next office version...when? Does anyone know if there is going to be a next version of Office soon? Like possibly next year when Longhorn is expected out? Peggy Tag: setting print area for multiple worksheets at once Tag: 69868
  - 13
    - Entering text that start with Zero ? How do I enter text that starts with a zero and have the cell show the zero. Example : 0256 0891 0188 etc Thank You. Tag: setting print area for multiple worksheets at once Tag: 69849
  - 14
    - 1 user? If I buy the latest version of Excel and/or Word, and it says it's for 1 user, does that mean that if I have a desktop and a laptop I can only install it on one computer? TIA Peggy Tag: setting print area for multiple worksheets at once Tag: 69848
  - 15
    - Linking rows Hi, I was wondering if somebody could help me. I have an excel workbook full of members' data. In the columns I have things like name, address, telephone, email etc On each row I have a different member. In addition to the main sheet I have added worksheets for each country. So besides having the main sheet which has all the members, I also have several sheets for each country represented containing only the members that are from that country. I was wondering whether I could somehow link the main sheet with the worksheets for each country. The idea is that if I make changes in the mainsheet they would automatically change in the country sheets too or vice versa. Is this possible? Thanks Timo Tag: setting print area for multiple worksheets at once Tag: 69846
  - 16
    - 50+50+17.5%=117.5 Hi All 50+50+17.5%=117.5 Yep, my problem is that simple, I don't know how to put the sum above into a formula in Excel :-( I've been reading a really good book here, tells me how to format this, resize that, but when it comes to actually doing any maths, not a word is said :-( So, here are my questions. 1, How do I right the formula for the above sum? And 2, anybody know of any good places on the net for teaching how to right the formula in excel. I'd like to say in advance thanks for any help Regards TC Tag: setting print area for multiple worksheets at once Tag: 69844
  - 17
    - VBA or Macro to auto fill a selected range Hello everyone, Here is my problem. I have a spreadsheet with four columns, which are variables nested within each other. What I am currently doing is going through a range, finding the blank cells, filling all the blanks with the value of the non-blank cell above it, and filling these blanks until I reach a non-blank cell. Simply put, all I am doing is clicking on the cell's handle and filling the blanks (it only fills the cells down until it finds a cell with a value). I am tediously going through each range of cells, autofilling down, and working from right to left. There must be an easier way where I can select the range of cells, run a macro, and it does the autofill for me. Any suggestions? Thanks in advance, Brock -- Btibert ------------------------------------------------------------------------ Btibert's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8559 View this thread: http://www.excelforum.com/showthread.php?threadid=397252 Tag: setting print area for multiple worksheets at once Tag: 69836
  - 18
    - lookup help Second try with this...I'll try to explain it better. I have a two-cell worksheet win workbook1. It is replaced every day, automatically with another two cell sheet in a new workbook with the same name. A1 is a date. B1 is number, eg. 1542. I want to automatically place the number into a cell in another workbook and sheet, by matching the date with dates in column A of the second sheet, and Column E (fillers)of the second sheet. I've been playing with match, offset and index, lookup etc. I've been able to get a number from DATE:E and have it show up in the first workbook.sheet, but that's the opposite of what I want to do. I can't have the formuala in the first workbook, because it will be overwritten each day. I would be thankful if someone could just point me in the right direction. Andy Tag: setting print area for multiple worksheets at once Tag: 69833
  - 19
    - Pivot table help I think ! Hi All, I have a report I need to create which goes as follows. I have a data list of around 56k records. The rows contain this; category 1, category 2, category 3, call id and Date I've created a pivot table with Cat1, cat2, cat 3 on the row area, Count of Call ID in the data area and date in the column area (this is grouped by Month). I'm looking at the months of Mar, Apr and May. I want to sort it, in descending order, by the difference of 'Count of Call ID' there is between Mar and May. If I cannot perform the calculation in the pivot table, is there a way of ungrouping the fields in a pivot table? So rather than it showing as below: Cat 1 Cat 2 Cat 3 Cat 2 Cat 3 Cat 2 It shows as: Cat 1 Cat 2 Cat 3 Cat 1 Cat 2 Cat 3 Cat 1 Cat 2 Many Thanks Adam Tag: setting print area for multiple worksheets at once Tag: 69831
  - 20
    - Filtering a worksheet if same value found in differnet columns Ok a little confusing to explain. I have a spreadsheet set up, where differnet columns may contain the same values for example: Col1 Col2 Col3 Item1 A Item2 H Item3 B A Item4 G H Item5 A What i would like to do is be able to filter on conditions if a value is found in either Col2 or Col3, for example "A" which would return item1, item3 and item5. I've not played to much with filters but would love to get this working. The tricky part is that the condition will change, eg today we need all enteries where "H" applies... tommorow "A" Should i give up in excel and go to Access?!?! Any help would be brill. B Tag: setting print area for multiple worksheets at once Tag: 69829
  - 21
    - Find duplicates then calculate..??? Right ok Say I have a worksheet with A1 - Contract No's, B1 - Serial No, C1 - Rental, D1 - Rebate. A Contract # B Serial C Rental D Rebate 1 40190158 1212121212 1100 10 2 40190583 4545454541 1000 10 3 40190583 4545454542 3000 30 4 40190583 4545454543 1000 10 5 40156124 1574516544 10206 102 6 75621564 6542156464 40240 402 7 75621564 4541145444 60240 602 8 45444451 4645125442 2053 21 I have a sheet with over 1000 orders on. At the moment where there are duplicate contract no's the same rebate is entered into all rebate fields for that same contract no (in other words there can be other 'machines' with the same contract no). So the rebate is being shown per machine where the value present is actually per contract. If there are no duplicates, then that simply means that there is only 1 machine on the contract. But where there are duplicate contract no's (individual serial no's), the rebate value needs to be divided up by ratio using the rental value. How can I easily do this? Preferably in 1 step. (so identify the duplicates, take the rebate for them all (which is repeated on each record for each machine on the dup contract, so its only nes to take it from 1 rebate field of a machine), then divide this value up using the rental value as the ratio (each one has a different rental value) and then dispaly the rebate for each. Please help! -- daleuk ------------------------------------------------------------------------ daleuk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26454 View this thread: http://www.excelforum.com/showthread.php?threadid=397197 Tag: setting print area for multiple worksheets at once Tag: 69827
  - 22
    - Rows not Resizing I have a spreadsheet which will wrap the text in the cells as selected but the row will not resize to fit the contents. Does anyone know a cause or a fix for this? -- Sigma ------------------------------------------------------------------------ Sigma's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26449 View this thread: http://www.excelforum.com/showthread.php?threadid=397190 Tag: setting print area for multiple worksheets at once Tag: 69826
  - 23
    - Using PastePicture Code? Andy Pope pointed me towards Stephen Bullen's PastePicture code as a way to export metafile graphics from Excel. But I'm a total VBA dummy - can someone please help me figure out how to make this work with my own charts? Thanks, Tammy Tag: setting print area for multiple worksheets at once Tag: 69824
  - 24
    - Validating Cells When validating cells, how do I set it so that you cannot leave a cell blank, i.e. it has to contain a number, even if the number is zero. I want a warning message to come up - I know how to do this, but I've tried different criteria and it always seems to allow having a blank cell, when I just want a zero in it instead, if it is to be blank. Please can someone help me. I hope this makes sense. Thanks, Discovery -- Discovery ------------------------------------------------------------------------ Discovery's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25859 View this thread: http://www.excelforum.com/showthread.php?threadid=397156 Tag: setting print area for multiple worksheets at once Tag: 69814
  - 25
    - Looking up columns hi there I've got 2 columns with various names in them, roughly 2000 of them! Each column might have the same name in them. What i want to do is to produce a new column/list, which consists of all the matching names from both columns. PLease can you help. Many thanks -- babiq ------------------------------------------------------------------------ babiq's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25480 View this thread: http://www.excelforum.com/showthread.php?threadid=397158 Tag: setting print area for multiple worksheets at once Tag: 69813

Hello -
Looking for a way to set the print area on a large number of simiarly
formatted worksheets at once. Ideally want to incorporate it into a
macro that does some other basic stuff as well.
Thanks for any suggestions!

--
annabel
------------------------------------------------------------------------
annabel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26520
View this thread: http://www.excelforum.com/showthread.php?threadid=397879

Top

Re: setting print area for multiple worksheets at once by dominicb

dominicb
Tue Aug 23 03:03:49 CDT 2005

Good morning Annabel

This code will loop through all your worksheets in a workbook and se
the range to A1:F30.

Sub SetRange()
For Each UsrSht In ActiveWorkbook.Worksheets
UsrSht.PageSetup.PrintArea = "$A$1:$F$30"
Next UsrSht
End Sub

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39787

Top

Re: setting print area for multiple worksheets at once by annabel

annabel
Tue Aug 23 14:29:03 CDT 2005

Thank you so much for your response. That is just what I needed.
I appreciate your help!

--
annabel
------------------------------------------------------------------------
annabel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26520
View this thread: http://www.excelforum.com/showthread.php?threadid=397879

Top