excel-vba

Hey all, I will get right to my question. I am trying to make a macro for a spreadsheet I've been asked to look at. There are 2 sheets that I'm focusing on this spreadsheet which are named Search & Update and Master. Master has a table named Table 1, which starts in column A to column Q. It's...

See a data entry form attached which is to be used to track staff movements, changes promotions over time. http://www.filedropper.com/formsheeteditopttest2-creatingonemastersheetv8forstackoverflow The data (AssociateData) lists all workers in the team and each worker has a row per month. The...

I am trying to loop through the items in SampleData2.xlsx and match them to the items in SampleData1.xlsx. If the item matches, I want to take the price and put it in the Column labeled "Complete". If anyone could offer some guidance, it would save me hours and possibly my sanity. Is this...

I am using a variable to reference the name of a sheet in my workbook. It works in one place, but not in another. I know (KNOW!) that I am missing something simple, but I'm not seeing it. Below are the appropriate lines, copied exactly from my VBA in case there are typos (but the error doesn't...

Hi, I have searched the whole internet and i couldn't find anything that matches my needs. I hope someone here can help me out. At work we make programs for CNC machines. Each program is saved the following: a letter (depends on machine), then 1,2 or 3(occur all 3 for every program), then the...

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px;"> 0down votefavorite I want a macro that can first identify top 3 value and merge these values together, and then...

Hi all. I hope you can help. I have a piece of code. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then copies and pastes that country into a new workbook, names the new workbook after...

Hi Every one I<gs id="2318bee7-d212-463e-b967-03ea1e18157b" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">'ve excel</gs> sheet (invoice)<gs id="4e1ac729-14e2-4409-a9a4-28598ad216f9"...

I've read that some suggest it is good practice to avoid using select, so I thought I would give it a go, having tied myself in knots trying to flip from sheet to sheet and file to file. I've written the following code, which does what it is intended to, copy a range from one file to another...

Hi guys.. i know this error has been posted several times but i can't seem to find the solution. Option Explicit Private Sub CommandButton1_Click() Dim buysignal As Range Dim OHLC As Range Dim ffdhigh As Range Dim sellsignal As Range Dim ffdlow As Range Dim cll As Range Dim i As Long i = 1...

Evening, All! I've come across a problem that I'm unable to find an answer to. Any help would be greatly appreciated. Please keep in mind that I don't consider myself an expert when it comes to VBA. I have learned a lot in the last couple years, but I'm definitely still learning...

I have a text file that I want to remove all quote marks from. I want to use vba excel. Is it possible?

For the rows that have a "Yes" highlighted, I'd need to run a loop and scan the closing prices from the date and time of the "Yes" row beginning 6:30 AM if it's the Minimum for the "Oversold" columns and if it's the maximum for the "Overbought" columns. An example would be on cell P8. The code...

I've written a code to copy the charts from a worksheet (in my excel workbook) to Ms-Paint and then saving the results. <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono"...

Hello!:) I am looking for a way to add the code that goes inside sub folders in an existing code that i wrote for consolidating data from multiple worksheet. I have tried several times with several different codes but couldn't add the code for looking in sub folders to my codes for...

I have a list of Names in the sheet "ClaimAnalysis", and a subset of these Name Values in the sheet "Analysis". To select the Names that have values in "Analysis1", I used Index-Match function for each value in the column of "ClaimAnalysis" (frow is the count of total rows in "ClaimAnalysis")...

<tbody> 1 down vote favorite I have a spreadsheet that there is a checkbox the purpose of the checkbox is to hide the name of clients in two adjacent columns. Because the spreadsheet changes from time to time the...

I keep getting Error 5 when trying to run my code. It seems to be this line that it has a problem with but I have no idea why: number = Worksheets("Front").Cells("C10").Value I have declared number as an integer. Any ideas?!

I'm going to try to make this explanation as simple as possible, but it's a fairly complex task, so let me know if I'm not clear. I have a sheet with data imported from another program (in which work orders are created and completed with closing resolutions). I have another sheet: column 1 has...

So here is my issue. I am trying to write a loop that performs a function using solver. Basically it starts in one cell, runs solver, moves the target and constraint cells to the right one, solves, moves target and contraint cells to the right 14, solves, right one, solves, right 14 solves...