Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel 2010 spreadsheet automatically create and rename

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-01-2011
Member
 
Join Date: Jul 2010
Posts: 52
Excel 2010 spreadsheet automatically create and rename
  

I have a little problem and hope you can help me. I have an Excel document in which it previously two sheets (1 "Overview", 2 "template") returns. On the paper "Overview" is a column name, which of J12 to J186 is complying with different long names. I would now like to copy the page template for each name corresponding to 1x and rename to the name. Unfortunately, my own macro knowledge of this are low. I would be happy if you had a proposal for me. Ever thank you.

Reply With Quote
  #2  
Old 15-01-2011
Member
 
Join Date: Apr 2010
Posts: 223
Re: Excel 2010 spreadsheet automatically create and rename

I think you need to use the PivotTable. Using a PivotTable report to summarize, analyze, examine and present the summary of the data in the worksheet or a source of external data. A PivotTable. report is especially useful when you need to add a long list of figures and the availability of aggregated data or subtotals may simplify the search for data from different perspectives, and the comparison of figures of similar data.
Reply With Quote
  #3  
Old 15-01-2011
Member
 
Join Date: Jul 2010
Posts: 52
Re: Excel 2010 spreadsheet automatically create and rename

First of all thank you for the help. Unfortunately, it does so not yet. If I run the Macro, is the runtime error 9 "Subscript out of range". When you debug it points to the line 3. I had first error that was due to too long name but a test with consecutive numbers brings the same error. Any other ideas please tell me how to go about this problem. Any help in this matter would be appreciated.
Reply With Quote
  #4  
Old 15-01-2011
Member
 
Join Date: Apr 2010
Posts: 223
Re: Excel 2010 spreadsheet automatically create and rename

You may incidentally in the VBA editor the cursor to any line between "Sub" and "End Sub" put in and then use the F8 key step tests performed macro that - if you change the content as the variable "new table" or the value of " Sheets.Count "(the number of leaves and hence the number provides the so far last table) want to check, simply point the mouse cursor to the corresponding part of the code. In the meantime, you can also change the Excel window (or equal to arrange two windows side by side), even if the will in this case is not too much ...
Reply With Quote
  #5  
Old 15-01-2011
Member
 
Join Date: May 2008
Posts: 923
Re: Excel 2010 spreadsheet automatically create and rename

With folders you mean probably spreadsheets, because as I understand sessions are workbooks and Excel files. So if you think spreadsheets, then could be to do something like this, with the tab name is in column J and the link or formula as in column K.

= IF (J12 <>""; HYPERLINK ("[Staff details.xls]" & J12 & "A1", "Link ");"")

However, the link - at least for me - not displayed in blue with an underscore Otherwise, could also do this by macro (in blue with underline).
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2010 spreadsheet automatically create and rename"
Thread Thread Starter Forum Replies Last Post
How to create Weekly Sales Report in Excel spreadsheet Lanka Boy MS Office Support 1 08-01-2012 03:57 PM
How to convert words into numbers in MS Excel 2010 spreadsheet K@ttY Windows Software 8 07-01-2012 09:37 AM
MS Excel 2010 spreadsheet is appearing too large Dhaani Windows Software 8 07-01-2012 09:36 AM
How to print only selected areas of a spreadsheet in MS Excel 2010? ramsun Windows Software 5 09-02-2010 08:30 AM
How to move data from one excel spreadsheet to another automatically? Arsenio Software Development 5 26-02-2009 07:44 PM


All times are GMT +5.5. The time now is 01:55 PM.