create new worksheet

As a follow up to the copy cell value to different worksheet with loop post, thanks to @rainbow7766 for getting the initial ask out there and @jolivanes for providing an efficient working solution, which was: Sub Maybe_So() Dim dataArr Dim lr As Long, lc As Long, i As Long, curSh Dim shT As...

Hi, I have a workbook where it got the the list as below in column B of sheet1. Can someone help me with VBA code to create each worksheet(in the same workbook) for each manager in the below list and worksheet name should be same as manager name. the list might change so whenever I run the code...

Hello everyone, I need to take a list of 5,500 rows which have an identifier in Column A and put all the rows associated with that identifier onto a new tab labeled with the identifier. My identifier is a "Plan Code" and each row contains asset data associated with that Plan. Some plans may...

Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...

Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...

I have an excel sheet (version 2010) with 359 company names in col A. I need to create a sheet for each of those names. I have been doing this manually and I've completed 129 so far but this is super tedious! Is there an easier way for me to do this? I've never written a VBA script or a macro...

Hi All, I need help for the below activity. I am not well versed in Macros. Below is the scenario. 1. I have one Workbook, with two Worksheets named as; "People" & "Masterfile" In People Worksheet the Data is as below: <tbody> Column A Column B Column C Column D Column E...

Hi all, I've managed to modify some code I've found on the site (Thanks RoyUK!), that I would like to perform an advanced filter on my data and create a sheet for each unique value, then copy and paste the data for the unique value. The code below, currently works if I use the file I...