#macro

Hello everyone! I am intending to hide specific columns such as column B,E,G. Also, to unhide it again if its hidden. So my intention is to create a button that when pressed, it first hides those specific columns, and if i were to press it again, it will unhide those hidden columns, and vice...

Hello, I am working on a worksheet with thousands of columns. The columns alternate between salary and quantity. I need to place the sum total for each salary column on row 51 and the average for each salary column will be calculated by dividing the sum of each salary by the number of salaries...

Hi, I hope someone can help me write a VBA that will copy a formula to every other column for a large worksheet with more than one thousand columns.

Hi, How can I copy a formula with more than a thousand columns to every other column in Excel?

Hello, I need a VBA macro that will find and highlight cells in the salary columns that have values less than 10,000 and find and highlight values in the quantity columns that are more than 100 or less than 1. Can someone help me with this? The columns look like this but there are more than a...

Hi Guys, I have the below code where I want a macro to run when a range of cells is selected(clicked). The code is: Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Sheet3.Range("Q1_COL")) Is Nothing Then...

Good morning. My son is learning Excel macros and he has run into an issue that has me stumped. He is recording a very simple excel macro on Excel 2016 that generates syntax errors when you attempt to run it. Looking at the generated code (posted below) it's clearly not going to run. The...

Here is the table to help you understand the problem. <tbody> r1 8B GA ID IL IN IW JT QG ABU-KOE 14 AEG-KNO 7 AMQ-BXB 1 AMQ-CGK 14 35 14 7 Routes Competitor ABU-KOE IW AMQ-CGK GA, ID, JT, QG </tbody> What...

At work I have a URL that has multiple parts, and I am able to reference specific cells in each sheet in my excel workbook. Some parts of the URL are the month, year, account, and the specific report type I would like to access. I have created a hyperlink that takes me to our company website...

Hello fellow Ex(perts), Recently, I have created a table that imports dynamic cryptocurrency data from this website: https://www.bithumb.com/ Since the data I wanted (real-time prices) are constantly updating, I use the "Refresh" tab to keep my data up-to-date. However, I was only able to...

Hello everyone, I have a question regarding TODAY() function in Powerpivot or maybe general in excel. My model and most of calculated formulas depend on function TODAY() as I have historic data with column SOURCE DATE and ewhen i am updating every day the values are calculated from the data of...

Hi All, I would like to have some help regarding the following macro. I would like to copy a range of values in a certain column and paste it down the same column 365 times, with offsetting one row. For an example; 1) Copy A2:A682 (This will always be the same) 2) Paste it in A684:A1364 3)...

I'm trying to make a macro.....but....I don't have no idea. Could you help? I wanna make like that. Step1. copy just one cell (B14) Step2. paste the coied cell to A15 Step3. again B15(copy) Step4. A16(Paste) Step5. again B16(copy) Step6. A17(Paste) Loop~ but if 'Project Total' value in the...

In a worksheet, I have three rows of data from three different sources. I need to get the data from whichever of three sources releases the most recent data.Example: Let's name the sources, Source 1, Source 2, and Source 3 in one column. In another column is "Last Update" which refers to the...

I am trying to find a row with a string value (for example "Safe") and want to delete all the rows leading from there. However, I am getting a type mismatch error in the last line (Rows("b:500").EntireRow.Delete). Can't seem to figure out whats wrong with my code!!!!! sheetname =...

Hi, I have looked everywhere for this, but couldn't find my exact problem. I have a listbox, with values 1 through 10. On selecting a value, I have a macro assigned to the listbox where am picking up the value from the target cell and hiding/unhiding an equal number of rows. It is a FORM...

Hi Everyone, I am new to Macros and am working on putting some macros in place for a spreadsheet that I am creating. I basically want to be able to Cut and delete the contents of a row if a certain cell says "Yes," and move the row into the next empty row of another sheet. So far I've gotten...

Hi, I'm pretty much a newbie at macros and so this may or may not be incredibly simple for some of you.. I have some excel spreadsheet where I want to delete all of the data in columns AA:AH apart from the headers. There are some blanks in the table which is making it a bit tricky. I tried...

Hi All I am using Excel 2007 and have a simple enough macro to paste data in to another sheet - simple is what I do best. :) Sub Macro1() ' ' Macro1 Macro With Sheets("data") .Range("B3").PasteSpecial xlPasteAll End With End Sub I am wanting to change this so that before it pastes any data...

Its it possible to count the number of worksheets in between specific sheets? For example, I have a "start" sheet and "end" sheet and need to count the number of worksheets in between. Is there a macro that does this? Thanks!