separate

  1. N

    How to separate duplicates into different files?

    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?
  2. M

    How to make a row auto populate

    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...
  3. G

    Key Word Search

    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...
  4. R

    VLookup and change output

    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...
  5. T

    Pivot Tables with multiple data tables

    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
  6. B

    how would i separate data that is separated by commas?

    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...
  7. L

    separate day,month, year from date using fx or text-to-columns

    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.
  8. H

    VBA to pull data from Multiple Worksheets into One

    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...
  9. S

    Ignore DDE, IgnoreRemoteRequests - 16.0 changes

    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 =...
  10. J

    Separate Dates With Blank, Unformatted Row

    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...
  11. S

    How to run a macro in a different macro?

    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...
  12. F

    How to track changes of a shared workbook in a separate workbook

    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...
  13. M

    Emailing direct from Excel

    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...
  14. N

    TimeValue(Substitute)

    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"))...
  15. J

    Creating separate workbooks using a macro

    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.
  16. D

    Formula Question

    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
  17. T

    Opening Excel files in a separate instance of Excel

    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
  18. T

    VBA code to copy and paste into workbook?

    What VBA code can copy and paste data in separate workbooks all in the same file folder with the same column headings and all on Sheet 1 into a separate workbook?
  19. R

    Merge Excel data to separate Excel forms

    Hi there Excel-people :biggrin: For part of my job I have to take data from one Excel list and make it in to separate Excelforms. It takes up so much time, which I don't have. So I was thinking... Is there a way to merge the Exceldatafile in to separate Excelforms? (We use the later as a sort...
  20. 8

    separate something in a cell.

    So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21 Is it possible to write a code that seperates the 100 and 1000 to another variable?

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top