Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-28-2022, 04:56 AM
pantakos pantakos is offline Create / Rename Worksheet based on other worksheets Windows 10 Create / Rename Worksheet based on other worksheets Office 2013
Novice
Create / Rename Worksheet based on other worksheets
 
Join Date: Feb 2018
Posts: 3
pantakos is on a distinguished road
Default Create / Rename Worksheet based on other worksheets

Hello all,

What I need to do is to rename the created sheet (Products) with the name of the sheets in ws , that are used for the calculations (fill Products worksheet with data).
The format will be TEMPLATE-games-play2 etc , only the sheets with data
Please find attached an example

Thank you



Cross posted Oops! We ran into some problems. | MrExcel Message Board and Rename Worksheet based on worksheets - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum
Attached Files
File Type: xlsm test6.xlsm (119.0 KB, 7 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
combining worksheets of same xls into a single worksheet pavan.polish Excel 2 03-14-2018 06:48 PM
Create / Rename Worksheet based on other worksheets How to copy workbooks from different worksheets into one new worksheet abbani Excel 3 12-12-2016 04:09 AM
Create / Rename Worksheet based on other worksheets Combining different worksheets into a single worksheet. jimmy2016 Excel Programming 4 10-15-2016 09:05 AM
Create / Rename Worksheet based on other worksheets copy cells from a worksheet into other worksheets based on Criteria Elton Wolter Excel Programming 4 04-16-2016 08:44 AM
Variable to rename a tab in a worksheet via VBA Chayes Excel Programming 5 08-07-2012 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft