separate

Hi, I have 1 workbook with 12 excel sheets. Each contains an invoice, and i need to export all sheets to different PDF files and under different names. Eg. Sheet 1 - > Invoice 01 ---> Invoice01.pdf Sheet 2 - > Invoice 02 ---> Invoice02.pdf Sheet 3 - > Invoice 03 ---> Invoice03.pdf Sheet 4 - >...

Hi All, I made a print worksheet design with checkboxes in vba excel, but I don't know how to print out a separate pdf. maybe someone can help me. Thank You Option Explicit Private Sub CheckBoxAll_Click() Dim formControl As MSForms.Control Dim cb As MSForms.CheckBox...

Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...

I have a list of 2500 contacts with their respective email, I have duplicate contacts but the different email, I need to separate the duplicates in different excel files to not generate spam when I export it. What should I do?

Hello, Thank you in advance for your help! So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this? For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...

I am currently using a nested '=find(text,cell)' formula to categorise a list for example. If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'. This I have done by nesting separate find fictions for each key work with an if statement...

Hello. I have a vlookup function looking up American citys/towns and returning the full state name that they are located in. How can I pull in the full state's name (how the data comes in), but then have it display the abbreviated state's name. Example: Florida -> FL. LEN( doesn't always...

I need to create a pivot table that references two data tables -- Budget table and an Actual Table. They are on separate worksheets, but how do I reference both data sheets? Thank you, Tom

I have a bunch of data that looks like this abc, def, 123, ghi The lengths of each string aren't consistent line over line. If an entire worksheet was like this I'd just go to Data/CSV and open it like that but this is just a small range. How would I separate values that are currently...

Hi if I have date like 13/1/2001, I know i can use day(), month() and year() to separate day, year and month. I also know I can use text to columns. Which method has advantage/disadvantage over other. Thank you so much.

Hello, I am very new to Excel VBA, i have worked on a few codes based on the forums available on MR Excel. I currently require a vba code for Debtors Management. I have 12 worksheets in a workbook each one for a separate month, in which i have a column called category in which i enter Debtors to...

Hi there, I'm wondering if anyone else uses the ignore DDE option the same way as I did, and have found a workaround to the issue I am facing, or if anyone can simply help with a solution/workaround. Previously when I checked the Ignore DDE option or used Application.IgnoreRemoteRequests =...

I have attached links to two spreadsheets: "Before" and "After." Here is what I am trying to do to "Before" so it ends up looking like "After." Separate dates as follows: if today is 9/16/19, I need the spreadsheet to only show 9/16, 9/17, and 9/18, removing all other rows of data and...

Hello, Thanks for reading. I can record simple macros using shapes. For example, I will paste in a shape, assign macro and then record away. However, there are instances whereby I have created more than 1 separate macros but I cannot seem to link them into one main macro. As a simple demo...

Hi All, Is there any chance to track the changes of a shared workbook in a separate workbook. Since the workbook needs to be shared with 20 users and adding the code to the same workbook will slow down the file. Since the file consists of 10 excel sheets. Please help in adding a code to...

I have a workbook that has several sheets (one for each person) - is there a way that I could email the contents of each sheet directly from Excel to the 'body' of an email. If this is feasible - where would the email addresses need to be located ( a separate sheet or on each individual sheet...

Hi, I am working with a spreadsheet that was pulled from an external data source. It imported the time column as text (example: 07:30m or 12:00am). No space between. I've gotten it to work if I break it into 2 separate columns using the following 2 formulas: =TIMEVALUE(SUBSTITUTE(D2,"pm"," pm"))...

Respected users, Can we create a macro which would help us to create separate workbooks; for example, we have workbook named A, can we create workbook B and workbook C using a macro function in workbook A? If not, is it possible using excel related time saving tools? Thank you.

I have the following formula: =SUM(SUMIFS('Raw Data'!J3:J25000,'Raw Data'!A3:A25000,{"400","401","405"},'Raw Data'!J3:J25000,">0")) The values "400", "401" and "405" will change, can I put those values in three separate cells and then reference the cells in this formula? Thanks, Dan

In Excel 2010, if I want my Excel file to open in a new instance of Excel, (when I open an Excel file via Windows Explorer), I simply add this line to my code: Application.RemoteRequest = True In Excel 365, do Excel files automatically open in a separate instance of Excel? Thanks