Hi All,
Hope everyone is well,
I require help with the following,
I have a sheet called data, which contains data exported from a piece of equipment.
I would like to breakdown this sheet into multiple sheets.
I require to create a copy of sheet '1', copy A15;E46 from 'Data', paste this into...
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...
Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge
Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge
Hi,
I'm trying to find a Macro to save the current worksheet I'm into a new workbook.
For example, when the user clicks the "Save Worksheet" Macro button, it'll save the worksheet they're in to a new workbook with
1. The new workbook named with the "old sheet name" + what information is in...
Hi All,
I have a workbook that has a master project worksheet page ("MAIN") that is a summary of all individual projects worksheets.
On the main page I want to assign code to a button that will add a new worksheet that is a copy of a template worksheet within the same workbook ("TEMPLATE")...
Hello, I am trying to get the new worksheet I am adding to be placed after the last workbook.
I want to replace the "Add" in the line:
"Set Dest_Sh = ActiveWorkbook.Worksheets.Add."
with
"Add(After:=mainWB.Sheets(mainWB.Sheets.Count)).
But, it is not working for me. Any thoughts...
Hey all! So I have some VBA that formats some data that I enter. But it formats it in the current tab. Then it messes up the tab and I cannot re-run the vba (linked to a button) without closing the spreadsheet, not saving it, then re-opening. I would like the data I put in to immediately be...
Hi All,
I am trying to create a VBA script to look through an automatic generated report on one of the tabs called "All". What I need it to do is look through Column "A" and find the unique Entries and how many times these unique entries appear. Then put the results in a new tab called...
Good morning all. Hope you are all well.
I have 6 Rows with the titles A1:F1
The lenth of the list will constantly change.
What i would like to do is filter column C.
Copy all the matching results to a new sheet with the sheets name renamed to the search criteria.
I would then like it to go...
Hello - I have data in Columns A:F in my original spreadsheet and have a macro that, when executed, will copy that same data and place it in those same columns in a new worksheet. What i'm looking for is to have columns A:E be copied into the new worksheet the same as it appears in original...
I have a quotation form that have two buttons.
One is click and will generate a new quote number.
Another is click and it will be save with the assigned path and file name format.
When I click on save File, the new saved files will also copy the buttons and macron, which I like to delete the...
I want to do a loop where you can copy say A3 worksheet 1 then add another sheet naming the work sheet "A3" then copying A3 worksheet 1 to A1 "A3". After that looping to A4 to a new work sheet naming the work sheet "A4"copying the value to A1 "A4", etc...
Is there a simply way of doing this...
I apologize in advance for any noob poster mistakes - I am very novice, trying to edit an Access database. I am trying to upload .xlsx data by changing a hard-coded workbook and worksheet name to a more flexible one. The worksheet name includes a date that will be changing every time this is...
Hello together,
I'm new here and I hope you can help me. I already search a lot, but I can't find any sufficient answer.
I have a lot of data (over 650 rows) and every row has more than 50 columns, so I really want to seperate the data.
The file is exported from a system which records many...
Hi all,
I'm working with Excel 2007 and Windows XP Professional and am needing a userform that will create a new worksheet, but only if a new worksheet is needed. I am adding new accounts and we want the data sorted by month on different worksheets. What I would like is a Date textbox that the...
Hey.
I'm trying to make a new worksheet with data for every change in Customer name. So, for example, the below table would represent the raw data on sheet 1. I want the macro to create a new worksheet whenever the Customer Name changes i.e. (Customer Name) =/= (Customer Name -1).
I want sheet...
I have a macro that creates new sheets for me from scratch. I need a macro (Sub TOfC) to be inseted in the Private Sub Worksheet_Activate() section. Is there a way of doing this. (If it helps the Sub is in a module called TOC).I am way out of my league with this one, so any help would be...
I have a userform with 4 textbox in it, and I want the information typed in those textbox to be saved in a NEW sheet on the same workbook.
For example, if I type information in those textbox, and I click the button SAVE, it will generate a new sheet and save the information there in cell B2...
I have created a "Time Clock" spreadsheet that is shared with other hourly employees in my office. I have some vba code which will copy a "template" worksheet and rename it according to the employee using the workbook. It works fine until I set the workbook to be a SHARED workbook.
How can I...