macro 2010

I have a form that requires pictures to be placed in it. I have added a button and assigned the following macro to set the size and placement of the picture I need. It works great, except the height does not fit correctly. It seems the height is being controlled by the aspect ratio of the...

I want to combine approx 100 items in column A with around 200 items in column B without having to do it by manually copying and pasting. Below is a simplified version of what I am trying to do. Can I do this with a Macro? <TBODY> A1 B1 A2 B2 A3 B3 </TBODY> <TBODY> A1 B1 A1...

I am new to Access and want to covert my database over from Excel where I am very confortable to Access. I have a problem with several fields in my tables though. I need to search one column of data and replace it with the correct data. Example: Column Depot has several misspellings that I need...

Hi, I have this data in excel sheet1: Component Name Partname BMW Car Engine BMW Car Body BMW Car Wheels Cesna APlane Rotor Rotor Spinner Blade Engine CarPart Piston...

Hello to all. If anyone could help I would be much appricative!! I would like for this macro to continue to copy and past data from one work sheet into another, but I am not sure how looping works. I put together a quick macro of what I basically trying to do. A2 will change to A3, A4, A5 and...

right now I have in column A =worksheet2!$A$2 and column B =Worksheet2!$B$1 for the first 41 cells and then the next 41 cells I have =worksheet2!$A$2 and column B =Worksheet2!$C$1. and so on. Problem is I would have to type this over and over again for 100s of different cells. Is there a...

How would I condese this into a small amount of lines and add additional rows/columns if I needed to Sub Converter() ' ' Converter Macro ' ' Keyboard Shortcut: Ctrl+Shift+H ' Sheets("Unconverted").Select Range("B2:AP2").Select Selection.Copy Sheets("Converted").Select...

I have a macro that print out a daily schedule just as I would like but now I am trying to add a couple more functions to it 1.After I print the file for the day I want to copy the sheet named "Today" and rename it as the next work day (M-F) date formatted as mmddyy, so if today is January 3...

HI... I wrote a code in sheet 1 of Book1_DT.xlsx for checking a cell value and then hyperlink to the corresponding Sheet...

Can anyone help me in creating a VBA/macro please as I'm not sure how to go about it. It would really help... The below link/picture is the data i have. https://www.dropbox.com/s/1hzdoqja61seyhs/Capture1.JPG I want the macro to look at column C and put one of the following in the cell next to...

Hi All: I'm pretty new to VBA. I have 30 different excel files under the same Folder G:\Functional Teams\Finance\2013\Consolidation & Reporting\ ( examples of the files names are Inventory.xls zpl1.xls zlge.xls ..... I would want to PDF all these excel files and save them under the same...

Hi, I have a set of data on a spreadsheet. The Column "A" contains Serial Nos. 1 to 5000. The Column "AT" contains the actual data and it extends upto 10 columns or so say till Columns "BC". The data is upto several rows around 3000 rows. Each of these rows contain data from Column "AT" to...