vba -help

I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.) I was...

So I may have bitten off more than i can chew. I'm trying to help a friend report on his mailing data but the data that he has is a DAFT code in them that you can convert into the USPS output report IMb digits to confirm they mailed and reached their destination. I should be able to use the...

Hi Everyone I need a big help. It is a task which involves extracting values based on matching dates. On my sheet1 of activeworkbook, I have dates in column B and the required data values in Column d I need the codes to extract the required data values (i.e.in Column D) from the master...

Hello there, I am using Excel 2010 Issue: On clicking the 'export' button embedded on worksheet gives the undesired result. So need to edit the code. Result: After clicking the button a dialogue box shows up with text 'Export Complete. Export files have been saved in XXXXXXXXXXXXX' Desired...

Hi, I'm trying to repeat an action which I think requires a "Do Until" loop but I'm not entirely sure if it does and I have no idea how to loop! So any help would be greatly appreciated! My current code is: Sub Quarter() ' ' Macro1 Macro ' ' If Range("A1") > 0 Then...

I have 2 VBA codes that i would like both to run when making a selection from a data validation drop down box. Could you please help me incorporate both so they will work. This code will let me select more than one item in a data validation drop down box. Private Sub Worksheet_Change(ByVal...

Basics: The column letter is static (something like column NX:NZ); the numbers of rows for a group can change. The math I want to perform would be positioned differently for each group. Details: I have data like the seen below – my sample shows three groups of various lengths, with one or more...

Hi, all! I'm a total newbie at VBA, and I'm trying to get this code to use some pre-defined variables to accurately define a range of cells within a column. This range is going to keep changing... there's a loop. If the code looks messy, that's probably due to my efforts to split everything up...

I am trying to VLOOKUP some value in 2 sheets and if the value is found then i am putting a hyperlink on the Sheet 1 cell to point it to the Sheet 2 cell. I have written an Excel formula for the same and it is working fine. But i am unable to convert it into a VBA formula. I tried many...

Hey, I'm trying to delete the blanks from a combobox drop down list - newbie to VBA so despite searching threads for solutions I'm unsure how to edit the code to suit my workbook. Any help much appreciated. Cal

The code below allows me to input a complete picture file name into cell (A2), press the “Refresh” control button, and the picture from the file name is displayed. Each time the “Refresh” button is clicked, it clears the current picture and refreshes the picture from the file name referenced in...

Hi Everyone, To be honest I'm not even sure if this is something that can be done with VBA, but since I consider myself a beginner when it comes to VBA code I figured this would be the place to ask. So, I have a worksheet full of data that has dollar amounts in column B and names in Column...

Hi All, This problem seems really simple in theory, but I'm very new to VBA so I've been trying to use past suggestions to similar problems and work from there but haven't been able to get very far. Basically, I need a way to identify rows off of a main worksheet called Lockbox 223064 based...

I am creating a Program within Visual Basic Editor, and It requires 3 chances to login. Any Ideas on how this would work. Thanks

So for work I need to create an excel spread sheet that uses a button/macro to take data from a form on Sheet 1 and copies it into a table on Sheet 2 in the appropriate places. Each time you use the button it needs to put the data in a new line on the table. I think I'm almost there but I can't...

I need to calculate something called a certain dates using something called Forward Pass and Backward Pass Methods(see below). Using the table(found at the link at the bottom) as an example (however macro needs do calculations using the lastrow with data inputed for the range). I need to...

I'm tracking user deadlines using a spreadsheet to keep an eye on what work is outstanding and make sure they don't miss their deadlines - theres other ways and means of doing this but this is the approaching I'm using now as a quick fix... Users have multiple entries and deadlines I want the...

Hi! I was hoping someone can help me with some VBA to loop through all the cells, or an active selection, and if it finds a cell with a formula that starts with "=VLOOKUP" or "GETPIVOTDATA", then copy and paste values for those cells. If it comes across a cell that starts with "=SUM" then it...

Hi all, I've managed to get my project nearly finished with a lot of help from this forum and i thank you all who helped. i have one last request thou, Which is to point me in the right direction. im trying to generate vba code which does this? when i click on the save button it asks me to...

Hi Dear, Plz Excel Macros help I need to replace in master file previous data with current status data using macros vba code. I have two files which is one is master file & one daily dump file with this I need to repalce with dump file in master file. Example: In master file i have order...