help - macros

Hi, I am trying to create the option to click a button/ field/ word on a line in an excel spreadsheet table that will generate a new tab which transfers some of the data from the fields on the row in to a new pre-defined template. The template requires the following fields to be populated from...

Basically im trying to filter a large set of data. I have people's names and want to delete all rows not containing these names. I used this macro originally: Sub DeleteRows() Dim Cell As Range, cRange As Range, LastRow As Long, x As Long LastRow = ActiveSheet.Cells(Rows.Count...

Hi hoping someone can help me. For some reason I cannot get the following to work. when the checkbox is ticked i.e. TRUE 1. unlock cell named "merchant" 2. clear merchant contents (a formula) 3. message box "Enter Merchant" (I've got this bit to work fine, where it falls apart is the...

Hi Guys, Thanks in advance for your help!!! I am trying to edit an existing sheet that we have at work. There is a button that clears all previous records and then a 2nd button that resets the formula. (The VBA for resetting the formula is pasted below) When I hit the reset button all cells...

I am really new to VBA's. I am trying to make a "create PDF" button to make a PDF out of the active tab. The file name would be using cells on the active tab then the name of the tab and then another cell. I would also like it to prompt the user if a file of the same name exist and I would like...

HI! Can anyone help me with figuring out the VBA code to unselect "Lock aspect ratio" and unselect "Relative to original picture size" and then resize all images and object in the active worksheet to a specific height and width? Thank you in advance. -Julie!

Hello everyone, I am pretty new to working with VBA with Excel. I've worked with a bunch of different coding languages but all pretty entry level. Anyways, I have been trying to make an inventory sheet for my place of employment (public library) that can do what we need. I have worked my way...

Hello amazing people, I was wondering can you help me with the below This is a current macro that I am using that copies everything (format, tab names, add data) and doesn't have formulas, removes the macros from the file also, works wonderfully, but is there a way to save the new excel into...

Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...

Hi All, I'm trying to run the Macro below but it crashes every time it get to the highlighted .Apply line. I have no idea why since it did not crash on the first .Apply line. Can someone please point me to the right direction? Thanks Dim arng As Range Dim brng As Range Dim crng As Range...

Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this: <colgroup><col width="170" style="width: 128pt; mso-width-source...

Hi, I would like to ask for help. I need to extract rows when it meets the criteria >=1. EX: Complete Product Sheet: <tbody> ProdCode ProdDesc Qty 1001 Prod1 0 1002 Prod2 1 1003 Prod3 2 1004 Prod4 0 1005 Prod5 1 </tbody> Order Product Sheet: <tbody> ProdCode ProdDesc Qty 1002...

Hi all, I'd need some help. I have the following VBA, and everything is working properly except the simplest thing: the automtical hide-unhide part I saw from Mr.Excel: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1...

Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...

Hi all As post title states, I am trying to write some VBA code that will save & rename Outlook attachments with the attachments filename along with yesterday's date. The attachments all have a string of 16 characters (date & time as numbers) at the end of each attachment. I wish to remove...

Hi! I am trying to automate a painful process. I have a workbook that has a lot of sumifs for four countries. I will have to save workbook 4 times and value past certain ranges. I am trying to automate this process with following code. Sub Hardcode_v1() Dim z As String Dim i As Integer Dim w...

Hello All, I have been searching for threads and while I can find some code for situations similar to mine, I can't seem to re-work the code to fit my specific situation. I just don't have a deep enough understanding of VB to understand how to modify the code. I have fleshed out what I am trying...

I have data in columns AB&C To find duplicate rows I concatenated the 3 cells in each row in 1 cell so now column D is occupied and duplicates of column D's cells denotes the duplicate rows. I want to keep 1 copy and clear the other duplicates (not delete rows but clear rows) I have been...

Hey guys, I've been working with macros for about a week or two, and while google is my friend, I think I need to reach out for some help. When I step through the code I've posted below, it works perfectly. No errors, everything formats correctly, and I end up with the desired result for the...

Hi there! I am in need of some VBA macro magic here. I have a stream of data that represents energy usage on an hourly basis. It is in one column currently that goes Day 1 HE 1, Day 1 HE 2, etc. I would like to have a macro that takes the 24 hours and transposes it into a table that has the...