called

  1. D

    extracting data from one workbook and pasting into another workbook automation

    I have two workbooks. https://1drv.ms/x/s!AvjBsEPEq12ngS2YS0oBxz5iM-e9?e=Yp3tbV Workbook 1 just has one sheet of data in a table format. There are many columns. One of them is called "Vendor" and is composed of the names of companies. Workbook 2 has many sheets. Each company name in the first...
  2. D

    updating all fields in a column in excel table

    I have inserted an excel table into my spreadsheet and I need to be able to update all rows of the table in column M with a 1 if a checkbox isn't selected and a 1.1 if it is selected. The table starts in column A and it is called npss_quote. The checkbox is called chkincrease. Can someone please...
  3. J

    VBA to save a .XLSM file as two different names in same folder and continue code uninterrupted

    Sorry for title, tried my best! I have a workbook called DPD.xlsm. I would like it that every time a user presses "save" it overwrites a different .xlsm workbook called "Import.xlsm" that always resides in the same folder directory it also needs to then save a second time as it normally would...
  4. M

    Formula which reads specific Sheet names

    Hi Is it possible to create a formula which reads subsequent Sheet names? So if I had data in Sheet 1, for example, I'd like cell A1 to read the name of Sheet 2 (which would be called 'Chocolate') cell A2 to read the name of Sheet 3 (which would be called 'Crisps') I know you can use...
  5. M

    How to combine two ranges vertically ?

    I have two ranges: R1 and R2. They have same header How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"? Thanks
  6. B

    Vba sort code

    if i had a sheet called 'Results By Customer' and column AK was called % Change. i wanted to build a macro then when you pressed the form it would filter that column by the top 10 customers by that criteria, i would also do another one for the bottom ten ty
  7. L

    I need help creating VBA code

    Workbook 1 is called NFL GRID SCHEDULE worksheet BUFFALO BILLS o Copy range B1:C17 Open workbook 2 NFL SCHEDULES If worksheet hide want it visible worksheet is called SETUP SCHEDULES autofit column B https://1drv.ms/x/s!AnJwxxiz0Ezpg8dbejTUGrxdz-U3aw?e=Fo08Sl...
  8. JenniferMurphy

    UDF called if any cell in any workbook is changed

    I have a UDF that is called from just one cell (D20) in just one sheet (Sheet1) in just one workbook (Book1). But if I change the contents of any cell in that sheet, or any other sheet in that workbook, or even any cell in any sheet in any open workbook, the UDF gets called. And it always gets...
  9. S

    Need Help Sending automatic emails depending on cell value

    Hello Ive, got a spreadsheet where column C is a list of drop down list of our curriers, and i want to know if its possible for it to send automatic emails when one of the cells is updated to a certain currier (in this case a currier called gopher) if so is it also possible for it to include the...
  10. Z

    Macro Help

    Hello, I need help from the experts. I'm creating an inventory file for all users and I have the main sheet called "Users" where I have a table with the names of the users in the column A, starting in the cell A1 and goes to A200. I need to create a new sheet using the sheet called "Template"...
  11. L

    worksheetS.copy vs worksheet.copy

    Hi I understand Worksheet.copy and what is used for. But to my surprise, I see Worksheets the collection has a functions called copy ,move and delete as well. What are these for? Thank you.
  12. T

    Macro to check if a file existists in the same folder

    Hi everyone, I have a macro that creates a file called "Times.xlsx" in the same folder the excel doc is in. I'd like to check if its already been created before running the macro. so I need a bit a the beginning that can look an this workbook filepath and see if a folder called "Tomes.xlsx" is...
  13. JenniferMurphy

    UDF sees cell in passed range as alternating numberic and empty

    I may be in over my head here, but I cannot figure out what the heck is going on. I have a complicated UDF that gets an error because one of the variables that gets data from a passed range is sometimes Empty and sometimes not. The UDF is called from several locations in the sheet. If I set the...
  14. A

    Sort Array of sheets to front of workbook

    Folks I had to have excel reinstalled recently and in doing so, the techy deleted my personal macro workbook. My fault, I should have told him to save that folder. Anyway, I am rebuilding from memory at the moment. just ran into my first problem. I used to have a neat little macro that would...
  15. L

    workbooks.open - with or without ( )

    Hi I understand that workbooks.open returns a workbook object. So it returns something and because of that, I thought it should be call using ( ) for example workbooks.open("abc.xlsx"), but the author of this link https://analysistabs.com/excel-vba/open-close-existing-workbook/ called...
  16. U

    View contents of table cell via VB

    Hi, I know this might sound like s stupid question, but how do I view the contents of a single cell of a table when I know the table name, the column heading and the row number. I have searched and searched Google and found all sorts of VB table related stuff but nothing to help me. I have a...
  17. T

    Creating a Document in same folder when another document is opened

    Hi Everyone, OK So heres what I need, I need two macros, 1 when the document is opened it creates a new document in the same folder called "Used" When the document is closed it deletes the docment called "Used" how can I do this. Thanks Tony
  18. C

    Display an alert if data already exists

    Hi everyone, I require some help creating an alert please. The situation is as follows. - I have a workbook called Invoices - There are two sheets in the workbook, one called Current and the other called Processed - Users enter in pertinent details daily and then a certain user processes the...
  19. K

    Very Hide/ Unhide Sheets with buttons

    I am trying to do the following and cannot piece it together. On a password protected tab called "Advanced Tab" Have three buttons or circles that do the following. button 1 - unhide all veryhidden sheets button 2 - veryhidden 5 sheets called "S2 R", "S2 M", "S2 C", "FT", "Totals" button 3...
  20. B

    VBA if Vlookup problem

    Hi, could someone help me with this please, I am ok with excel but new to vba and my problem is this: I have a userform with just a few textboxes and it is the first one I am having trouble with, I would have done it ages ago in excel but anyway, the userform is on a sheet called "start" and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top