export a macro sheet

Hi Team, I am working on a request where an excel sheet has few columns with columns format like(SSN , ZIP code and YYYYMMDD format) data. Now on the same sheet there is a button. If I click on that button, then all the sheet data will be exported to a new excel sheet and that will be saved into...

Hi, I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet. There are about 100 different options (100 different Sites) in the drop-down list. I am...

Dear Excel Gurus, I have an Excel file that splits Bill of Materials (BOM) explosions into the correct templates for our ERP system. We copy-paste the BOM of our customers in worksheet "BOM INSERT", we fill in a few data points in "INSTRUCTIONS", and the data automatically fills in Worksheets...

Hi, Can someone help me with below requirement. I have a macro work book with data in the sheet "Source". this data has multiple columns and in the column "N"(which is last column which contains data) i have manager names along with blanks and "NA". I want to filter each Manager and copy the...

Hi All, I was wondering if there is a way you could write a macro so that one sheet, when a button is pressed, could be exported to a new workbook with values only as the formulas within the sheet are linked to other sheets. I was also wondering if i could automatically name the file depending...

Hey there, So I have a spreadsheet right now that looks like this: <colgroup><col span="5"></colgroup><tbody> Name Surname Company Income Address John Smith General Motors 100000 (Address1) Peter Jackson Hilton Hotels 70000 (Address1) Peter Jackson Hilton Hotels 70000 (Address2)...

I am using an export code to take my worksheets to a destined folder in xlsm format. I am looking to adjust this formula so when the worksheets are exported it is a flat file that just contains the values in the cells NOT the formulas. Sub CreateWorkbooks()Dim wbDest As Workbook Dim wbSource As...

Hi I would like a macro that would select specific sheets based off the tab name using a list on a separate tab, move them to a new workbook and save in a location that i would specify (Locally). Basically, in a one excel sheet I have list of salesman's names (tab is called ‘TM list’ and a...

Hi I would like a macro that would select specific sheets based off the tab name using a list on a separate tab, move them to a new workbook and save in a location that i would specify. Basically, in a one excel sheet I have list of salesman's names and a corresponding tab in the same workbook...

i have created a excel sheet. that has, command buttons, a user form(progress bar) and some macros. the sheet works fine on my computer. however when i try to open the sheet in my friends computer. it displays an error that, object not present( i think its because of the user form). kindly...