copy to new sheet

I have a data dump. There are some names on a sheet. On clicking the button, copy the active cell and filter the pivot table and copy the entire table content and create a new sheet and paste the cell on the new sheet. I am not sure this is workable, if so, please help.

I am in need of a VBA to copy range E2:O100 and R2:AJ100 and place them on a new worksheet starting at the third row Column E thanks in advance for any and all help

I am in need of a VBA macro I can apply to a button to copy range E2:O100 and R2:AJ100 on work sheet titled "Historical Orders" to its own new worksheet beginning at cell A2. The new worksheet can have sheet1/2/3/etc. as a name that does not matter. This process will be repeated every few...

Hello Everyone, I was wondering if someone can help me with automating a fairly manual task. I have a batch job that saves a number of excel files to a folder. Each file has a unique name beginning. Here are some sample file names: 010_3010 dd-mm-yyyy _Summary.xls 010_3042 dd-mm-yyyy...

Hi, I am trying to update a report with a list of cost centres and copy each report created to a new tab. The sheets in my workbook are called: CC List CC REP The steps I am trying to code into a for next loop are as follows: update a specific cell (criteria key for a sum if) on CC...

Good Afternoon, I have searched a few things before creating this post so I apologize in advance if this was already done. The ones I have seen perform somewhat of what I'm trying to do, but not to the exact and my VBA/Formatting/Pivot knowledge is very very minimal. What I'm trying to do is...

Hi forum members, I am obviously lacking in the VBA knowledge department, and am trying to create a summary sheet consisting of data that is collected from five other worksheets in the same workbook. On the sheets the data is being collected from I am checking various named ranges for the...

I have set up a workbook with sheets named for each month. I have 70+ separate excel files (one for each month) that each have a single sheet I want to copy into the new workbook's corresponding month sheet. Each file is named different but the name of the sheet in those files that I need will...

Hello, I am trying to use the vba code below to copy and paste simmilar data from a very large excel sheet where column A has unique identifiers and this is how I would like to seprate my different excel sheets that will be created with the vba code. But i get stuck on "Set stName =...