macros

Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...

I work as a sales data analyst for a clothing manufacturer. And I often make sales reports that are structured by Brand-season-Category. I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ? A macro with constant strings will...

Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...

Hello, we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I...

Hello there! I have tried several things and I am getting stuck on the best way to get the results that I need. I have a large spreadsheet, columns A - CR Each row list out one expense item and has information based on that item filled into columns thru CR. Finance is wanting a report that if...

Hi, I have seen a few thread on this, however none have worked specifically for what I am trying to do. I am create a template for a form that users will fill out in excel. The form is divided in sections and a few of these sections require an "Add New Row" button. I have the button set up...

I am trying to improve some of the processes we have at work to minimize emails and eliminate redundant tasks. I am generally pretty good with the formulas for Excel, but I have not used VBA/Macros at all. What I'm wondering is if it is possible to do the following below. I want to learn how to...

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

Hi, I'm very new to VBA and I was faced with a task to improve our file (table format) further. I would like to know how to grab the values from range N:Q and R:U when the Correct Setup column is "No" and paste these values to a new downloaded sheet in the Downloads folder. This is stacking...

I'm looking to make a super simple macro that just pulls the text out of a shape and uses that to unhide and open a tab on click. Sub ButtonToHiddenSheet() Dim ShtName As String ShtName = SHAPE TEXT Sheets(ShtName).Visible = xlSheetVisible Sheets(ShtName).Select End Sub I...

Hi, I need such a code which should copy this range A2:D2 and then paste as simple numbers into this range A1:D1. When i run this code again then it should copy this range A3:D3 and then paste as simple numbers into this range A1:D1. When i run this code again then it should copy this range...

Hey All, I'm getting the error that no cells have been found when running the following code. Although it is correct and no cells have been found under the criteria I've put, I want the code to just move on and continue with the code. Could anyone help me to do this? I am a beginner when it...

Hello Everyone Been scouring these forums for a few days before deciding to make my own account... There's been many topics that come extremely close to what I'm looking for, yet none have been the exact same to my knowledge. So, I'd like for the entire workbook to be Password protected upon...

Dear All, I have to randomly select six clusters/ villages using PPS method (Probability proportional to size) for a geographic unit for surveys. I already have an excel file that does it for me using macro (Module1: RUN_CLUSTER) and generates PDF files using the macro (Module2) I have a fixed...

I just started working on compiling all of the sub contractors and material vendors we have with pricing. What I would like to do is give each contractor their own work sheet page so I can keep up with pricing changes year to year. This will create a lot of worksheets in one work book. Would it...

Can anyone help me adjust my macro. I just need it so that any rows with Value 'Q' in Column A are skipped and not exported to the pipe seperated sheet ? Thanks. Alex Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord As Range Dim myField As...

Hello, I have a task to generate a sheet containing following headers : Part Number, Quantity, Date The quantity to be produced is given in one more sheet and that quantity needs to be distributed in that particular month. For example: In the vba code, it has to refer the particular month...

I am trying to find some code that will allow me to move data from one sheet to another based on criteria. Ex.) If the row has the word "claimed" in it, I want the values in columns BB-BG to get moved to the new sheet, NOT the entire row. Ideally, the code will make each row in the new sheet...

Hi guys, I am relatively new to Excel so please excuse any errors or stupidity on my part. I have a dataset from which I need to filter out values. The data range is from Column A to Column AA. In columns V to AA I have some vlookups that are returning the value of #N/A. I need the VBA to work...

I’m getting this error to populate my worksheet from another software provided by my company. Can you help me solve this?