Copy worksheet and rename sheet

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- 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
    - Search for data and return multiple fields I have a massive spreadsheet of around 8,000 rows and tons of data. Is there a way I can set up a separate worksheet as a front sheet where I can type in the name of a company in a cell on the front sheet and it will search for the name of the company in the data sheet and pull it up along with all the other details of that company? My main issue is that I'd want to use "*" in the search field and that there may be multiple contacts for one company. Is there a way to start typing the text to search for and have the cell autofill from the list of company names? Using the filter option on the main data sheet would be best to find everything quickly, but this is for our salespeople so it needs to be as user friendly as possible and easy for them to print off. Tag: Copy worksheet and rename sheet Tag: 802896
  - 2
    - excel sheet. what does the error "cannot shift cells off sheet" means? how can i rectify this? Tag: Copy worksheet and rename sheet Tag: 802887
  - 3
    - Sheet renaming and use as data I have a file with about 80 worksheets. How can I create a list in another sheet that reflects all the sheet names Tag: Copy worksheet and rename sheet Tag: 802879
  - 4
    - Save file as a .dwg or .dxf file Is there a way of saving a spreadsheet or a selected range as a .dwg or .dxf file? I am trying to copy a range from excel 2000 and insert it into a cad package. Ideally i would like this to be automatic therefore VBA code would be good. Tag: Copy worksheet and rename sheet Tag: 802878
  - 5
    - Remove characters If I a have a anme like O'Brien or De La Hoya or Van-Basten, how do I remove the charcters from the names. I want my answer to be OBRIEN, DELAHOYA AND VANBASTER Tag: Copy worksheet and rename sheet Tag: 802866
  - 6
    - auto caps lock hi, how to set outo caps loc (beside turn on caps lock button) at sepcifiy cell. if any latter enter into cell , he will change to caps lock . rgds ramzi Tag: Copy worksheet and rename sheet Tag: 802862
  - 7
    - Identifying quarter to which a date belongs? how to identify the quarter to which the following date belongs '31/3/2007' in excel? please let me know what function i should apply on the cell to get the quarter. like in the above case answer comes out to be - 1. Thanks, Harsh Tag: Copy worksheet and rename sheet Tag: 802861
  - 8
    - Display text at random Hi all... Can anyone please post a detailed way of how I can display text lines at random in a specific cell when I press a macro button. The text is pre-typed in the module I would assume. Also how can I set all this up to work together? It would a great help if anyone can assist. Thanks Tag: Copy worksheet and rename sheet Tag: 802860
  - 9
    - Precedents Hi All, I am using sumif worksheet function in sheet I would like to give an example here... Apples 100 Apples 100 Mangos 150 Apples 10 I am using this formula in cell B5: =Sumif(A1:A4,A5,B1:B4) I just want that when I press Ctrl + [ in my sumif holding formula it select only those cell that meets my given criteria specification, rather select the range A1:B5. is there any way to this Tag: Copy worksheet and rename sheet Tag: 802857
  - 10
    - Prevent filldown Can I use an event macro to prevent the user from using the fill handle on unprotected cells? The issue is data validation. Column B has a list validation. (For example: Tom1,Dick1,Harry1) If the user chooses "Tom1" from the drop-down list in cell B1, then uses the fill handle to fill down, B2 will read "Tom2", B3 will read "Tom3" etc, which is not prevented by data validation. Excel 2000. Thanks in advance Dave, Tag: Copy worksheet and rename sheet Tag: 802854
  - 11
    - Conditional Format a cell in time increments I have a macro running a timestamp for cell "d" when I make a change to cell "c". How can I make it also change the cell colors of cell "d" after intervals of 8, 16 & 24 hours (yellow, orange, red)? Tag: Copy worksheet and rename sheet Tag: 802849
  - 12
    - Find within an embedded document object Hi! I'm working with a large workbook (40+ worksheets, many of which of embedded Word document objects in them). When I do a search and/or replace on a word in the normal Excel workbook, the word is not located/identified within the document objects. Is there a way to set Excel so that it will include the embedded pieces in the search? Tag: Copy worksheet and rename sheet Tag: 802845
  - 13
    - Array to Populate ListBox Problem I have a dynamic array that has two columns, i.e. myarray(7,0) Reading up on dynamic arrays, it seems like only the last column can be expanded. I'd like to populate a listbox using the array, hence something like: entry.listbox = myarray Only when this is done, it's the first column that's entered in the listbox, but I want the second column to be the one to populate the listbox. I could break it up into two arrays rather than one (and actually have), but am still curious to see if this is possible. Thanks. -np Tag: Copy worksheet and rename sheet Tag: 802832
  - 14
    - Indirect and sumif functions with multiple workbooks I have one workbook that basically needs to use a sumif function with the sum range being an indirect reference to a named range. This works when the named range is in the same workbook as the sumif formula, but I am having trouble getting the sumif function to work using an indirect reference to a named range in a different workbook. I tried the following formula to no avail to reference the named range, assuming 'store alignment g1' and 'store alignment g2' refer to the other file's name and tab respecitvely: =SUMIF('[Total Country Data File (District & Store P&L).xls]IS Data'!$B$5:$B$40243,F3=SUMIF('[Total Country Data File (District & Store P&L).xls]IS Data'!$B$5:$B$40243,F3,(INDIRECT(("'["&'Store Alignment'!G1&".xls]"&'Store Alignment'!G2&"'!"Indirect(h1))))) Indirect H1 is on the sheet where my sumif formula is, and it is referring to a named cell range on the other open workbook (total country data file). Can you nest indirect formulas like this? Is there another way to sum a named range in another workbook? Tag: Copy worksheet and rename sheet Tag: 802826
  - 15
    - Formula needed for adding every nth column on another sheet Hi I have tried everything I can think of but with no luck - can somebody please help. On sheet 2 I have all the data in columns from rows 1-20. On sheet 1 I want the total of the sums of every 3rd column. ie. Sheet 1: A1 = sum Sheet 2: A1:A20 Sheet 1: B1 = sum Sheet 2: D1:D20 Sheet 1: C1 = sum Sheet 2: G1:G20 and so on... Instead of manually entering all the formulas on Sheet 1 for the sum totals of every 3rd column, is there a formula I can enter in A1 on Sheet 1 and copy across the row? Thanks for any help!! Tag: Copy worksheet and rename sheet Tag: 802819
  - 16
    - Saving email addresses from excel document I have an excel document with a great number of email addresses which I want to have put into my address book. I don't want to have to type them over. Is there a way to select and send them to the address book? Tag: Copy worksheet and rename sheet Tag: 802814
  - 17
    - Create error message if number entered is greater than previous ce I want to create some sort of error message or warning if the user enters a number that is higher than the cell before it. How can this be done? Thanks! -Joe Lewis Tag: Copy worksheet and rename sheet Tag: 802811
  - 18
    - Adding a range with three variables I have a spreadsheet that has site, job title and FTE. I want to add the FTE by site and job title. I use for two variables the sumif function but can not get it to work with three. For example, Site Job Title FTE Beaverton NP 1.0 Beaverton RN 0.8 Hillsboro NP 0.8 Hillsboro RN 1.0 etc. This list is longer that this but I need to add the total of FTE for a person who is a NP and works in Beaverton. Can someone help. Thanks. I have Excel 2003. -- Thank you. Tag: Copy worksheet and rename sheet Tag: 802805
  - 19
    - Can't sum a series of numbers I copied two sets of numbers based on two different queries from the same source into a spreadhseet. The first set of numbers I copied into the spreadsheet will sum up fine. The second set of numbers will not sum. I tried reformatting the cells as number with 2 decimal places and then when I highlight the cells the bottom right tally shows a count not a sum as I'd expect. There are no $ signs, no commas, etc. and I have already tried reformatting the cells in various different number formats (number with 2 decimals, currency, etc.) and that doesn't help. If I manually type over the figure in the cell it will then be included in the sum total (without changing any formatting). This is a very large spreadsheet and it is not practical to retype everything. Is there a way to reformat the cells which I've not tried that might work? Any other suggestions to get them to total up? Thanks in advance for any help you can render. Tag: Copy worksheet and rename sheet Tag: 802803
  - 20
    - Labels on data points in chart Is there a way to associate labels with data points in a series, and then have the data points appear on a chart? I don't want to directly apply the labels to the chart, but instead, I'd like to be able to maintain the data over a period of time, and add data points to the series. Each point would have a data label that would remain associated with the point, and would appear any time the graph is updated. Thanks. Tag: Copy worksheet and rename sheet Tag: 802801
  - 21
    - auto group row and/or rows I would like to group the cells that are filled in column A automatically. If A2 is filled I would like it to be grouped. I also need to group cells A10-A15 together is they are filled. In this example I would have 2 different groupings of rows; A2 and A10-A15. Tag: Copy worksheet and rename sheet Tag: 802798
  - 22
    - filling a single cell before the sum of the previous rows. In other spreadsheet programs, you would create a spreadsheet with the following information, row by row 21 10 15 15 1 then you would request a sum of the rows and wth some formatting it would look like this: 21 10 15 15 1 -- 62 where the - is, you would use \- and press enter to fill the single cell. Can this be done in any and or all versions of excel and how is this done. Tag: Copy worksheet and rename sheet Tag: 802793
  - 23
    - Rounding by .05 I have a formula where the cell multiplies the answer of 100/60. I put the formula in as =A2*100/60 The answer comes out as 53.33333. I want the answer to round up to 53.35, when I add the roundup in front of the A2 to rounds up to 54.00, Can someone tell me how I can make it round to the nearest .05? Tag: Copy worksheet and rename sheet Tag: 802791
  - 24
    - Selecting a range of cells in a macro Can anyone help me with this please. I have written an Excel (XP) macro that has to start by selecting a range based on the active cell and the 10 cells to its right. How do I put this into VBA code please? Thanks, V Tag: Copy worksheet and rename sheet Tag: 802789
  - 25
    - how i can refer to cell in long formula go to another file ='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1 this is a formula in the specific cell but i have more than 150 files.xlsx and i have to merge it in one sheet can any one give me a way to make this idea possiable a b c d e 1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx 2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1 3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1 4 ='C:\Documents and Settings\VENUS\Desktop\[B3]1'!$A$1 that mean i will refer the name of the file in the furmula to the cell A1 B1 C1 etc. i have tried many ways but it doesn't run so kindly and expert tell me the way to do that with the file name and the sheet that i give (1) for it names also in the same way Tag: Copy worksheet and rename sheet Tag: 802788
- Next
  - 1
    - MATCH() or VLOOKUP() across mutliple 65K sheets possible? 2003 Imported a large file into 3 Excel w/s. The w/s are identical in format. Is there a way to perform a VLOOKUP() or MATCH() across three 65K sheets? ANY other ideas? TIA EagleOne Tag: Copy worksheet and rename sheet Tag: 802785
  - 2
    - remove spaces in front of text I need to remove the 4 and the 9 spaces after so my cell F55 will only read Educate patient/care giver regarding behavior modification program purpose, goals, and use in home/community environment instead of 4 Educate patient/care giver regarding behavior modification program purpose, goals, and use in home/community environment. Any suggestions Tag: Copy worksheet and rename sheet Tag: 802783
  - 3
    - Pivot Table Help Needed!!!! Hi, I have a pivot table that shows data as below. I donot have any columns in pivot table. Row Data Total January --- Total no. of requests --> 10 ( I have created using count ) Total no. of rejects --> 2 ( I have created using count ) % of Rejects --> 20% ( I am not able to get this 20% ) for some reason Febru --- Total no. of requests ---> 5 Total no. of rejects ---> 4 % of Rejects ---> 80% ( Not able to get this ) Total Requests ---> 15 Total Rejects ---> 6 Total % of Rejects ---> 40% ( Not able to get this ) Below is what I am getting. Row Data Total January --- Total no. of requests --> 10 ( I have created using count ) Total no. of rejects --> 33.34% ( I have created using count ) % of Rejects --> 20% Febru --- Total no. of requests ---> 5 Total no. of rejects ---> 4 % of Rejects ---> 66.67% Total Requests ---> 15 Total Rejects ---> 6 Total % of Rejects ---> 100% It is getting the % of total. Could you please help me get the desired result. Also, I need to set the graph color out of this pivot table if let's say the % of rejects are more than 35% show the bar in red, if it is more than 25% and less than 35% show in yellow and if it is less than 25% show them in green. Could someone please help me resolve this. Thanks a lot in advance for your help. Tag: Copy worksheet and rename sheet Tag: 802778
  - 4
    - Convertion of Star Office documents to Microsoft Office I was recently forced to upgrade to a new computer, with Vista installed. Much of my previous hardware and software won't run under Vista. This includes Star Office 7. I have a number of documents and spreadsheets, that I need to view. Is there a free convertion utility, that will let me read them in MS Office Home & Student 2007 (or anywhere else for that matter). Tag: Copy worksheet and rename sheet Tag: 802775
  - 5
    - Adding values generated by "IF" Statement I have a spreadhseet that contains an "IF" statement as follows: =IF(D5>0,"Â£150.00","0"). This statement works fine. I want to add up the total at the bottom of the column containing the formula, but the =SUM function doesn't appear to recognise the Â£150.00 as a value - I cannot get it to "see" the amount. I know this probably has a very simple solution but I've been working 12-14 hour days for 3 weeks without a break and cannot work out the solution myself. Any help would be more appreciated than a bottle of gin tonight. Thanks Tag: Copy worksheet and rename sheet Tag: 802769
  - 6
    - Tidal Times I'm a yachtsman and need to mark tidal times on tidal atlases. For the non-sailor, a tidal atlas shows on each page a geographical area with a representation of tidal speed and direction for each hour up to 6 hrs before or after high water at a standard port. Doing this manually is tedious. I want to create an Excel 2000 spreadsheet that will automatically show hourly up to 6 hrs before and 6 hrs after the time of high water for each day that I type in. For example, if I type in a high water time of 23 Mar 08 2345 (perhaps in 2 adjacent colums), I would like automatically for the spreadsheet to display to the left 23 Mar 08 2245, 23 Mar 2145 and so on up to 6 hrs before high water. At the same time I would like it to display to the right 24 Mar 08 0045 (note date change), 24 Mar 0145 etc up to 6 hrs after high water time. I've tried to work this out but am stumped. Can anyone suggest a way? Tag: Copy worksheet and rename sheet Tag: 802768
  - 7
    - Macro for Pivot in MS Excel 2003 vs 2007 Hi, I have the following macro that clears all filters in a pivot table of mine in 2007: Sheets(2).PivotTables("PivotTable1").ClearAllFilters. When I try to run the macro in 2003 I get an error message that says: "Object doesn't support the property or method." Any ideas for how I can clear all filters in my pivot table in excel 2003 using a macro. Thanks. Tag: Copy worksheet and rename sheet Tag: 802765
  - 8
    - how do you add cell values to drop down list for other cells Hi there, I hope I put this so its easy to understand so here goes. I want to make a drop down list (easy, Done) But this is the hard part I cant work out. I want to be able to have other values attached to the drop down list that appear in other cells. eg. below. In Cell A1 is the drop down list. And I want to add values to the items in that list that show up in the cells C1-C8 depending on what it makes. eg. in the drop down list say wooden box wooden barral So for wooden box I want to have in C1 2(for the number of planks needed in C2 I want 20 for nails in C3 1 for a handle But when I choose the barral from the drop down list I want it to say 10 in C1 for planks 50 in C2 for nails 0 in C3 for the handle I know it can be done as I have seen a sheet like it but its protected with a password and I dont know whos it is. So can anyone explane how to do it, if needed I can try and explane better with a pick or put the sheep up so you can see it. Tag: Copy worksheet and rename sheet Tag: 802761
  - 9
    - Excel 2007 creating reports for diffrerent products one at a time Help! I created a pivot table from an OLAP cube to show net sales and other information for all products in a department. I added the product code and department code to the report filter to allow me to filter on a product or a department. Then I converted the pivot table to formulas, formatted the report. and now I want to use this report going forward to distribute to different departments every week. The problem is I can't filter on department code (neither product code)from within the report. Any help will be appreciated. Thanks, Rima Department Code 003 Product Code All Net Sales Retail Retail Year Retail Week 2008 Department Product Primary Size 2008 W1 2008 W2 003 - Men's Knits 00301-0013 - L/S SMU THRML XL 00301-0023 - L/S PLAQUET L $14.98 $65.06 00301-0024 - L/S MOD SLUB XL $25.06 00301-0026 - L/S PCE FNGRS L $25.85 Tag: Copy worksheet and rename sheet Tag: 802759
  - 10
    - automatically enter today's date as a static entry in Excel Good day, I have a spreadsheet where when this is opened I would like the time/date it was opened to be static so I can know when the last changes were made. I have created a macro button for paste special but is there away to do this without clicking somewhere meaning as soon as the file is opened the time /date gets stamped in a particulr cell without hitting save? Appreciate anyone's help on this thanks TJ Tag: Copy worksheet and rename sheet Tag: 802753
  - 11
    - Manually changing a picture (shape) name property I've got several bitmaps pasted on Sheet1 that I need to refer to in VBA. However, I'm having trouble figuring out which is which. I'd like to name each with something easy to remember, but when I bring up the properties tab (even when the picture is selected) it gives me the worksheet properties and not the picture properties. I tried cycling through the images with VBA (thinking I could figure out which was which and assign names through code) but it is telling me there are more pictures than actually exist on the sheet, which makes me think that Excel considers the extra pictures I deleted to still be present- which makes it even harder to figure out which are which. So, can anyone tell me how to find and change the name property of a shape/picture? Thanks! Keith Tag: Copy worksheet and rename sheet Tag: 802752
  - 12
    - Extracting URL from Hyperlink I have a spreadsheet with several hundred website entries listed. Each one of them is a hyperlink where the hyperlink displays as "xyz company". In order to extract the URL to a different cell, I have to right click, select "Edit Hyperlink" then highlight the URL and copy it, hit cancel, and then paste the URL into another cell. Is there an easier way? Excel 2003 SP2 Tag: Copy worksheet and rename sheet Tag: 802736
  - 13
    - NESTED OR FORMULAS Is it possible to string together nested OR formulas in a similar way to nested IFs? I keep trying to bring this off by modeling the OR nesting after IF nesting, but Excel is telling me I'm entering too many arguments. -- William Tag: Copy worksheet and rename sheet Tag: 802735
  - 14
    - Find if there is a matching number in another column is there a way to take two sets of data and mark a third column when the number from the fist column has a match anywhere in the set (range) of data for the other column? for instance i have 3 columns A B C 1 9 3 9 4 is there a formula that would return a marker in column C by asking the question "if B1 = any number in column A return an "X""? Tag: Copy worksheet and rename sheet Tag: 802732
  - 15
    - Remove Header/Title from list I have several lists created and use them for pull downs on various sheets. I would like to eliminate the title row such as "Column 1". I have added my own titles instead of "Column 1" but would prefer no header as this becomes a valid selection in the pull down. Any suggestions? -- Dar Tag: Copy worksheet and rename sheet Tag: 802728
  - 16
    - Dynamic Data validation Lists Trying to create dynamic validation List (s) After referring to one cell I need the data list to populate. If the reference cell changes the data list changes. Example: - Reference cell = A1 Columns D2, E2 and F2 have data populated Columns have headings, One, Two and Three If in cell A1 I input One, the List (DV) is from D2 to "list" end. If in cell A1 if I input Two, the List (DV) is from E2 to "list" end If in cell A1 if I input Three, the List (DV) is from F2 to "list" end Help greatly appreciated! -- Crunchies Tag: Copy worksheet and rename sheet Tag: 802727
  - 17
    - Open Form when file opened How do I create a form to open when a file/spreadsheet is opened? Example: Dept Name Hours Vac Sick Total adb Joe 24 8 8 40(sum of the hours entry) The form would just be the information above to key in. when the file is opened I want the keyer to see the fields that need to be keyed in. I don't care if she can see the spreadsheet or not while she is keying in information. also the ability to 'Add New Employee' Tag: Copy worksheet and rename sheet Tag: 802724
  - 18
    - Delete Hidden Named Range Everytime I open a certain Excel file, I get a message saying that I have links to another spreadsheet. I think these link references may be caused by a hidden named range. How can I find all of the hidden named ranges in a spreadsheet and how can I delete the ones that may be causing this? Thanks. Tag: Copy worksheet and rename sheet Tag: 802721
  - 19
    - Determine if column contains duplicate value Is there a way to determine if a column range contains a duplicate value with a formula in one cell? The formula would return 1 if there are no repeating values and 0 if a value is found more than once. Tag: Copy worksheet and rename sheet Tag: 802717
  - 20
    - deleted files Can you recover a deleted file? Tag: Copy worksheet and rename sheet Tag: 802714
  - 21
    - Protect files from deletion How can I protect a file from being deleted by another user on a network? Tag: Copy worksheet and rename sheet Tag: 802711
  - 22
    - DISABLE AUTO CONVERT FOR GOD'S SAKE! When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! Tag: Copy worksheet and rename sheet Tag: 802709
  - 23
    - Importing images to scale I am trying to insert JPGS into an excel file. Seems to work fine but they are not to scale. A picture that should be 3.5" wide is 3 .75" wide. What am I dong wrong? Thanks, Peter Tag: Copy worksheet and rename sheet Tag: 802697
  - 24
    - Paste Special in Excel 2003 Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d Tag: Copy worksheet and rename sheet Tag: 802688
  - 25
    - Another Lookup Question I have a table of data where the top row contains this month's dates, and the cell beneath each date contains a bank balance. Can you please help me create a formula to put in the far right column(directly after the last date of the month) that will return the value of the second to last bank balance I have entered. For example, today (7/24) I entered a balance, so I want the formula to automatically update with the bank balance of 7/23. Thanks in advance! Tag: Copy worksheet and rename sheet Tag: 802686

How can I copy a worksheet and rename at the same time?

RE: Copy worksheet and rename sheet by GarysStudent

GarysStudent
Fri Jul 25 06:33:00 CDT 2008

Put the new name in a cell, say A1 and run this macro:

Sub Macro1()
ActiveSheet.Copy After:=Sheets(1)
ActiveSheet.Name = Range("A1").Value
End Sub

--
Gary''s Student - gsnu200796

"Ernst - EXE Graphics" wrote:

> How can I copy a worksheet and rename at the same time?

Re: Copy worksheet and rename sheet by John

John
Fri Jul 25 06:50:45 CDT 2008

If I got you right! just do a "Save-As"
HTH
John
"Ernst - EXE Graphics" <ErnstEXEGraphics@discussions.microsoft.com> wrote in
message news:523A3D3B-BD3D-4EE5-B06C-6B6379D01843@microsoft.com...
> How can I copy a worksheet and rename at the same time?

Re: Copy worksheet and rename sheet by Don

Don
Fri Jul 25 07:08:27 CDT 2008

OP said sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"John" <johnd@newlook.com> wrote in message
news:Ogoutyk7IHA.3260@TK2MSFTNGP03.phx.gbl...
> If I got you right! just do a "Save-As"
> HTH
> John
> "Ernst - EXE Graphics" <ErnstEXEGraphics@discussions.microsoft.com> wrote
> in message news:523A3D3B-BD3D-4EE5-B06C-6B6379D01843@microsoft.com...
>> How can I copy a worksheet and rename at the same time?
>

Re: Copy worksheet and rename sheet by John

John
Fri Jul 25 07:18:41 CDT 2008

Thanks Don, I knew I needed more coffee this morning.
John
"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:u2vuw8k7IHA.2064@TK2MSFTNGP02.phx.gbl...
> OP said sheet
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@austin.rr.com
> "John" <johnd@newlook.com> wrote in message
> news:Ogoutyk7IHA.3260@TK2MSFTNGP03.phx.gbl...
>> If I got you right! just do a "Save-As"
>> HTH
>> John
>> "Ernst - EXE Graphics" <ErnstEXEGraphics@discussions.microsoft.com> wrote
>> in message news:523A3D3B-BD3D-4EE5-B06C-6B6379D01843@microsoft.com...
>>> How can I copy a worksheet and rename at the same time?
>>
>