called

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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