help macro

Hi Guys, I need your help with my vba code. :) I need to locate the duplicates from column A, leave just 1 row of that column and add the sum of column N (the rest of the columns don't matter). Below it's an example of my raw data (A column and N column) Account number Amount 102105709...

Okay. So i have copy and pasted a UDF that lets me find the value from the selected cell in a table located in another worksheet. Now what i need is for it to work in a different workbook too. here is the UDF: Function FindValueInTable(MyWorksheetName As String, MyValue As Variant, Optional...

The below listed macro auto sort (sorting each of my rows by reverse alphabetical order) was working just fine. Then I put in some conditional formatting to highlight upcoming, current, and past dates. Not my auto sort is not working. Is there a way to make them both work or is one interfering...

Hi guys, I've created a sheet for clients to fill in, some cells are mandatory and require filling in. I have no problem with the blank cells, however some contain drop down boxes with the title "click here to select" or "click here for more options" Obviously if the cell remains as "click...

I'm currently recording a macro to to read a .txt file apply, then a function will be applied to the data and then graph it. However excel's x-axis scaling isn't as friendly to use as it appears. I need my data to begin being read at 100 centimeters but I only want the x axis to show spacing...

For some reason I cannot attach the file but I have a master with employees info on it as well as date and than a timesheet template that looks like below. Basically I want to have Master sheet w/ date and employees name and craft code generate into individual timesheets Below is an...

Basically I want to have Master sheet w/ date and employees name and craft code generate into individual timesheets Below is an example, I already have the finished product Timesheet I just need a formula or Macro to generate these from the master list. <tbody> PERFORMANCE MECHANICAL INC...

All, I am building a new hire form in excel and for audit purposes when we print certain information needs to be redacted. The best way I've come up with so far is to make a macro that will: 1. select the cells I want to change 2. change font color to the same as the background 3. print active...

Hi all, I'm currently working on a spreadsheet and I need to be able to filter it based on state (theres only about 6). I built a different macro for each state that automatically filters like if you were to do it manually. My plan was to chain together a few IF statements in a cell to execute...

I have a large inventory database (almost 8,000 rows by 38 columns) generated by querying many different spreadsheets. The queries are merged into one giant table that I would like to search from. Each row contains many columns of information about the piece of equipment that someone might...

I have a problem with sharing an excel product, so I'm left at the mercy on relying on others to close out the product when they're done. This workbook is utilized by many people, but can't be shared due to the tables and formulas therein. So, how can I create an Auto-Save Auto-close...

Hello Guys, Please help me.. I have large data in Excel sheet in following format <tbody> A 32423 2234325 12131 11231 2534R 323422 1245 224241 112125 21212 353453 464363 545352 12423 123525 22424 B 114343 12342 2E23R 1342 1423R 25346 1324 1234 2525 1234 2522 </tbody> I want to...

First of all, thanks to everyone who has helped me on my current project. I currently have a code to prompt for password before saving a metrics file, which only a handful of people know the password (and not too many are bright enough here to look in VBA to find the password :rofl:) I was...

Hi I am trying to create a worksheet to keep track of good and bad things that are happening to certain employees. Here is a test sheet that I put together just need it to be able to actually work. What I want is when I check the employees in the list and press the button labeled good it adds...

Hi! I'm from Spain and I'm tryng to emulate the buscarv function with VBA. I'm using the Vlookup property but it doesn't work. Appears the 2042 error. What I do wrong? I supose that could be something relationed about the format of te cells... but I'm not sure... Dim Fecha As Date Dim...

Hey guys, I have been looking for a cubic b-spline vba code in which I can specify the knots on the curve. Does anyone have it available? Any help would be appreciated. I am striking out... Thanks.

I'm having a rough time creating a macro to do what I need. I know I'm going to need a couple of them to achieve the effect ultimately, but I'm going to start with it in a smaller scale. I have a table that is say about 50 lines. It has 7 columns. I'm looking for it to update a word document but...

Hi All, The worksheets I have, require deleting all columns shaded green on row 13. Up to and including column 150. I have a spreadsheet with headers on row 13, and a few thousand rows of data thereafter. Variable number of columns, starting from 100 to several hundred depending. My problem...

Moshi Moshi I am very new to excel. I learned it because I suddenly was given a large amount of data to organize. Unfortunately, I cannot figure out a way to make the code below run without crashing after spitting out a few solutions. By "crashing" I mean I am forced to restart Excel and VBA...

Hello and thank you in advance...I have a large spreadsheet that is exported from an application. I need to have a macro that will find all rows for each state and copy the row into a new worksheet labeled by each state and delete the rows that it copied. I would like to do this automatically...