help - macros

  1. B

    Macro to Assign "UniqueID's" to Judges tables for a competition

    Hello all, I am using the following macro to assign UniqueID from one sheet into a judges table sheet Sub AssignUniqueIDs() Dim sourceSheet As Worksheet Dim destinationSheet As Worksheet Dim judgeSheet As Worksheet Dim lastRowSource As Long Dim lastRowDestination As Long...
  2. J

    Copy Paste Multiple Worksheets w/ variable ranges into 1 master sheet vba code

    I created a workbook with multiple time cards (1 for each employee on different sheets). I need a vba code to copy and paste from each sheet into a compiled master sheet ("Data") The first line of data in each timecard sheet is in B8:H8. Some timecards could have a variable amount of lines from...
  3. S

    when I copy the table as picture, another one is creating from the same table, using VBA macro

    guys i made a macro in excel i want to copy the table when i run this macro the table area duplicating itself please help me, thanks Sub screenshot() Dim w As Worksheet Range("D1:F7").Select Selection.Copy Range("C4").Select ActiveSheet.Pictures.Paste.Select 'when i remove this...
  4. M

    Help : Inventory Database

    Hi, I'm trying to create an Inventory Count Database in Excel using a Macro/VBA. The concept is for the Count Team to enter in an Item Number and Bin Number (which I have Data Validation on to prevent typos/errors). The Item Description is a formula that will pull the description associated...
  5. K

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...
  6. D

    Create a diary entry from populating a line in a tracker spreadsheet

    Afternoon all, Firstly I'm not even sure if this can be done, so I guess that is the first hurdle. Secondly, If it can can I have some help with even starting the coding/recording a macro as I can't even think how to start this. what I'm trying to do: Using the below table when I enter a new...
  7. tazeo

    Need help with copying worksheets and creating pivot tables/charts in new workbooks using Macro

    I've been working on a report that I clean and collate using PowerQuery, and it's been fantastic. However, I'm facing a slight issue when it comes to taking the output (which has been split into worksheets, with one worksheet for each work group) and creating a new workbook for each sheet. My...
  8. S

    Disable manual printing just only done by macro-vba in excel

    I want to disable print for all users manually, Just print only from the macro assign button (want to use for small office billing invoices) Sub PostToRegister() Dim WS1 As worksheet Dim WS2 As worksheet Set WS1 = Worksheets("INVOICE") Set WS2 = Worksheets("DATABASE") WS2.Unprotect...
  9. C

    Consolidation

    I would like to consolidate columns A2:I2 based on the criteria that A2:D2 are the same on the next row. I have attached photos of the whole document to provide how this is supposed to work. I cannot seem to figure out consolidation and I maybe overlooking it. I have the code pasted below...
  10. P

    Simple replace value with a certain value by column macro

    Hi, I'm trying to create a macro that will replace all the "1"s in a column with a value in Range "A1", then move onto column 2 and replace it with the value in Range "B1" and so on. this is what I have so far Sub Macro2() ' ' Macro2 Macro Dim X As Integer X = InputBox("What column...
  11. S

    Weird behavior of the toggle button

    Hello, So, I have a question if you have ever encountered this, if it's normal or how to solve this problem. I am new to macros, and for my project in work I have a table with information. However, this table is important for three different departments, and every department needs different...
  12. N

    VBA Code to transpose data from a Folder into a single workbook Table

    Hi All, I am wondering if anyone could help me please? I have been given a folder called "CPET" which contains an number of workbooks which all of which have unique data but on the same rows and columns for each work book (please see the picture below). I have been asked to put all this data...
  13. I

    How to automatically update macro after adding a row?

    I'm currently creating a sheet for some weekly workouts and I wanted to create a randomize button, using macros, that takes an x amount of exercises from a list and assigns them to their respective place - this way the workouts wouldn't get repetitive over time. I'm veeery new to VBA coding, so...
  14. Z

    Saving workbook as multiple cell values...so close to working. Could someone assist to get me there?

    Hello all I'm trying to set up a new spreadsheet for compiling quotes for my company. I've next to never used VBA before so this might as well be Greek to me. I'm trying to get two buttons to work The first, being the "Save Workbook As". I found the code below and copy/pasted and it seems to...
  15. D

    VBA Sum Multiple Columns and Duplicate Rows

    Hi! I am new here and just started learning vba codes. I was wondering, I have searched alot but Could not find a specific code where I would be able to sum the A column of the duplicates of B to D columns and deleting the duplicates. The original Data would be like QTY UOM ITEMS...
  16. Y

    Autofill a dynamic Table 2 with a dynamic Table 1? (Criteria-based)

    Howdy dear Excel specialists, This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft. So I have this main table that regroups all...
  17. M

    Append/combine multiple worksheets from workbooks into one workbook

    Dear Patrons, Newbie here. I want to append/combine the highlighted worksheets- 5 int & 7 lql (screenshot Item 1) from multiple workbooks - 20220601, 20220602, 20220603.........(screenshot Item 2) into two worksheets in a new empty workbook - Master File (screenshot Item 3) . Any help is...
  18. K

    Deleting rows that are not on a second list

    Hi Guys and Gals Bit Stumped on wraping my head round how to get his done but basicly am looking to make a macro that would look threw a list of unique code then delete any codes that are not on the list in a complete list The complete list of products looks a little like this(information...
  19. C

    VBA question

    I have two sheets. On sheet one, column B starts from row 6 with a list of dates. On sheet two, column D starts from row 2 with another list of dates. I am trying to create a macro that highlights the whole row starting from column D in sheet one if there is a match between the dates in sheet...
  20. S

    Excel to Word

    I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.). QUESTION: I need to create a way to automate moving the required data from...

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