add

Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...

Hi, I am very much a beginner with excel, but wanting to add a button on my spreadsheet to add a column after a specific column. The code I have put together is as follows: Sub AddColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter Column Letter where you want to add a...

Totally new to this so I have this formula in the formula bar for a cell =+ALLDATA!BN6. I want to put an IF statement saying that if T6/220 >= 7.5 then BN6 else BM6. Also what is the exclamation point for

<tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT

I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...

I have a row of 10 numbers and each week i add numbers. What i want to do is have a formula that will average the last 4 numbers in that row of numbers when i add numbers to the row of numbers. So what im saying is i want to be able to always adverage the last 4 number that have been entered...

I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the...

Dear all, I'm struggling with a code to move columns values into rows, except the first column. Of course, it will be needed to add rows and populate the blanks in the first column. Probably, an example will make my exercise easier to understand: An important point is that the number of...

Hi The + sign in the sheet tab that is used to add a new sheet, is it the Worksheets "Collection" object in VBA? Thank you.

Afternoon guys, I'm trying to find an efficient method to add a hyperlink to a range of cells but what I have so far keeps generating an 'Out of memory' message. The code itself runs fine, but once it's complete I get the message. This is what I have so far: LastImportRow =...

Hello Guys, I am actually having an issue where i am using dependant drop down with excel and i want to add to my existing formula data for 24 and 36 months planning, can someone help me please as my actual formula is as per below: =INDEX(ListeMois,MOD($AB$29+COLUMNS($E$54:E54),12)+1) in fact...

Hello, like i said probably an easy thing to do but im not able to search properly for what I want to do, basically I would like to take a current total, and add to it when another cell total changes, except i already am seeing errors in what i want to do. So i think i want a macro so after all...

Hi, I have a macro I use to distribute an email attachment and screen shot to a defined emails user list (noted on cell U9 and U10) - this works Ok but is there a way I can add a fixed text field at the start of the email so the user know what this is about? "Please find attached some...

Hi all I'm trying to speed up the transpose process. When I copy an order form from online it pastes it all into Col A but I need to make it easier to read as I already have the next stages in place. The problem is the site changes from time to time and I have to redo the sheet. The common...

So I have a UserForm that I’m working on and have beentrying to hide/show a certain Label and Textbox based on the value of a ComboBox. The code I am usingto do this is – 'hide HolidayRentTB & HolidayRentLa If (PropertyTypeCB.Value) = "Single Unit" Or "Ex-Pat" Or "Holiday Let / AST"...

Is it possible to add the User Name to each record that's being added to a table? I am using an Append Query to add the new record(s). I thought I could create a field in my query to do that, by what I am trying doesn't work CreatedBy: Environ("Username")

I am trying to figure out how to build a macro to spot missing sequence and add in a new row when found. There should be 1440 data points in column A The date and time formatting goes as followed 10/10/2019 7:41 10/10/2019 7:42 10/10/2019 7:43 10/10/2019 7:44 10/10/2019 7:45 10/10/2019 7:46...

I a MakeTable Query. I want to add an AutoNumber field to that table after the query is run. Is there a way to do that using VBA? tbl_vluVendor_MakeTable FOUND THE ANSWER: CurrentDb.Execute "ALTER TABLE tbl_vluVendor_MakeTable ADD COLUMN ColumnName COUNTER" Thanks!

https://1drv.ms/x/s!AvjBsEPEq12ngUm0YmMHEk1HGIPY?e=npLKjO My data has account numbers and their corresponding $ value Trying to add the $ value for those accounts which are not in the list in Column E I.e. add column B except the items highlighted in grey How best would you go about it? (My...

Hi all, I have a large spreadsheet pulling results from multiple tabs into one pivot table to track the status of various things. Within this, there are several different rules for several different manufacturers. I have a current formula in cell N2 which is...