called

Hi All, I am trying to do two things with a userform. #1 : add a new row to bottom of existing table, the table is called "Table1". (my current code does this part just fine) #2 , populate the first cell in that new row with a textbox.text that is in a userform called UserForm1, the text box...

Hello all. Thank you in advance for any help I will try and explain and I hope someone can help. I have a book called book 1. I would like some VBA in book 1 which will vlookup column A in a closed workbook called Book 2 returning column g of book 2 in column g of book 1. The only problem is...

Hi all, I have a userform which opens and needs to display a date value in a text box at the top. The box is called "DateBox" I'm unsure on whether this is the right code, and where it needs to go. The Sub "Automationopen" loads "AutomationCP" AutomationCP has a module called...

Hi. I am trying to create a simple update checker, but not sure how to proceed. What i got is this: A workbook that is called VData.xlsm, with a button which has me.userform1.commandbutton4.visible = false Now, what i want, is every 1 min, the file checks another workbook, which is called...

Hi I know Macros are written in vba code but I guess people usually refer to Macros when a user "recorded" the steps. Then the result of this recording is called Macro. But when a user open VBE and write the code, people do not call it Macro but they called code or sub. Am I right?

I need some help with a formula to calculate this, I think I need a sumif formula but I am not sure. I have a excel table that calculates costs of services. The table is called npss_quote. There is a totals column called "Price ex. GST". There is a drop down menu with 5 services and the...

Hi I have a data model in SSAS. I can connect to it happily using 'live connection'. I see all the tables, and their relationships appear to be in place (I can't see this directly in 'live' mode of course, but reports join as expected). However, if I try to load some of the tables in 'import'...

Hi, I have multiple tabs on a worksheet, and I want each individual tab to be saved in a location depending on the name of the tab. The actual name of the file would be the tab name, plus the contents of cell A1. So for example, if the tab is called "Bananas" and has "1234" in cell A1, the...

I have a procedure to transfer some data from a table in one workbook to a table in another workbook. I want to be able to sort everything in the destination table by date in ascending order after the transfer but I am not sure of the vba code. The date is in column A of both workbooks The...

Hi, I have headers in row 1, with data underneath. For every change in column A, I want the data (plus the headers) copied and pasted into a new tab. I then want that tab to be named the same as the data then in cell A2 of the new tabs. So, if there are 7 rows with "Bananas", I want those 7...

hi guys. im tryign to compare addresses on column A vs column B and needs to show what is the percentage of similarity. this is my code so far, one sheet called CM, sheet2 called ABC, sheet 3 called MATCH copy both to here and show percentage. my code is below but im not sure why something...

Hello hello hello, I'm trying to replace a formula within a Macro to optimise my code a bit. Previously, this was written and references a workbook called Capacity that was already opened previously in the code: Range("Z3:Z" & Lastrow).FormulaR1C1 =...

I have several worksheets in my workbook, I need cell A2 to reference the tab or worksheet name of that worksheet. for example, worksheet 1 is called summary in cell a2 I need it to say summary, worksheet 2 is called ALB and need cell a2 in that worksheet to say ALB. Thanks

I need to copy data A2:F100000 from 10+ workbooks, sheet1 (all in the same folder called “LC”) into one workbook called “Masterfile” in the sheet called “Data”. However since it is about 100 000 rows of data in each workbook I need to first filter out each row where the value in column E and F...

Hi there, I would like to double click on a value within a sheet called Capacity, for it to be filtered out on another sheet, called Status. In Status, I have a table range already done called Details, and the column to be searched from is B4, any ideas? Thanks

I want to delete all the rows in an excel table except the first and clear the contents, but not delete the formulas in the row. Can someone help me with the excel code. The sheet is called home and the table is called tblCosting. Thanks, Dave

I use Excel for Office 365 in Windows 10. I have a spreadsheet called C:/Desktop/tkxl_f.xlsm which can have from two to twenty five sheets each with different and variable names and always located between a sheet called Blank and a sheet called Cover. I wish to copy and paste the range A1:K133...

I have a table and as new rows get added, I need some vba code to enter a 1 into the column AB on the new row. Can someone help me with the syntax please? The table is located on a sheet called "home" and is called tblCosting. There are things below the table, so you can't use the xlup method of...

Hi, On google I found a few methods for this which require to copy paste to another worksheet etc, but was wondering if there is an easier way to perform what I am trying to do. I have a table called "Invoices" which has a column called "Status" (Column 14). What I need done, is a macro that...

Hi, I am used to set up dropdowns from tables. For example I set up a table called TblBU that I fill with all business units. I select then the column without the tiltle (Business Units) and name it BU_List (so it refers to =TblBU[Busuness Units]), which I use as dropdown source. The reason for...