macros

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?

Hi. Probably a macro beginners question. Apologies and thanks in advance. So everyday I download "report A", the cells range are different because things get bought/sold. Ex: A3:L900 and the next day is A3:L1000. *Simple example: Day 1: Macro starts recording on a sheet with data range A3:L900 -...

Hi! Looking for some help with macros. I've never used them before. Basically, I need a list of employees (Index Worksheet) to be split on two separate worksheets (IndexDriver worksheet, IndexLaborer worksheet). I have the code to complete this task, but I need it to not duplicate these rows...

Hello all, I am trying to automate a task that I regularly have to do at work however I don't have much experience using VBA/Macros so I was hoping someone could help? I will try my best to explain what I want to do in words but I have also got a mini sheet below which should make it a lot...

Hi all, I was wondering if you could help me with this problem I have (I include an image for reference), I am trying to clean and sort a list of products that gives me a system that I can not change. What I am trying to do is to copy the value enclosed in red (product group mark) from the...