vba & excel 2007

Hi I am trying to create a macro to send emails automatically via outlook. Currently i have the raw data which i have sorted according to the Send code mentioned below ,separated the sheets based on the account field. Now i need a code to send email to specific email id based on the send code...

Hi all, Please teach me how I can display only columns with certain text in Excel 2007? There are a lot of help on filtering rows but I am hoping to create either a toggle button or set up a reference cell (say "B4") along with a VBA to display columns with selected days only. For example...

I have a worksheet named "Summary". Column "A" to column "Q" have variable numbers of data. The number of rows are not fixed(dynamic) for a column. Also Sometimes one or more column are empty or all the cells in a column have missing data. Now, I want to create a LineMarkers chart from each...

Hello Please find my requirements. I have 2 sets of data which needs to be sorted to ascending order. Headers starts from Row 4. 1st data is with headers 'Account(with numbers- Col A and 'Total-Col B (with positive & negative values also ). 2nd data is with the same headers and values-Col D &...

Hi All, I have an info sheet, which looks something like this <colgroup><col span="7"></colgroup><tbody> USE CASE OUTPUT 1 OUTPUT 2 OUTPUT 3 OUTPUT 4 OUTPUT 5 OUTPUT 6 User 1 Plan 1 Check 1 Review 1 Prototype Test 1 Communicate User 2 Plan 2 Check 2 Review 2 Type A Test 2 Review User 3...

HI guys. I would like to copy rows from multiple worksheets (Jan to Dec) that contain certain text - WON, PENDING, LOST - When a VBA Button is pressed on another Worksheet the information is copied to VIEW. So far i can copy from only one worksheet at a time. CODE so far Sub CopyWONtoView()...

Hello, I need to copy data from worksheet "Records" to worksheet "Reviews" based on date (msg. box= which date?). In worksheet "Records" date is in column "BV". I need to copy column "C", "D","BU", "BV","BW", "BX" from worksheet "Records" when particular date of interest matches and paste it to...

Whats a simple code for copying columns (A2, B2, C2) from sheet 1 into Cells on sheet 2 (A7, B7, C7) needing this for a macro and adding a command button that just copies it.

Hi all, In each row of column A & B given is image location. Now in C [in each respective row] I want to insert columnA.rowX image, then over it the columnB.rowX image receptively. Both image dimension should be L=600 x B=400 [Original is different].

If column B2 has Husband, B3 has Wife, B4-B5 has Child then starts over, how can I index each family unit ie: column A2 through A4 = 1 and increases with additional families. <tbody> Index Member 1 Husband 1 Wife 1 Child 1 Child 2 Husband 2 Wife 2 Child 3 Husband 3 Wife 4...

HI I am importing data where the name is one column and in this format: Lastname,Firstname I would like to have one column for First name and one for last name. Can I do this in a macro?

Even though i can write little bit VB code, I am relative beginner, hence i would like if someone could help me with this. I have set up a perfect loop, that changes cell values from named table here is code: Sub LoopThroughForEachCellInARange() Dim OutputAddress As String Dim rng As...

VBA: I have a list of file names in between empty cells of column A. I want their complete location in the next row if the file exists in asked folder by the code. Consider the sub-folders in folder to get the file locations.

Hi, Im currently looking to to create a macro that will pull together entries from multiple worksheets and paste them into a single table on my main worksheets. This involves matching the names in column A to the names on worksheets for each month and matching the correct monthly value based on...

I am hoping the Excel Gurus can help. Using Excel 2007 I am looking to merge cells in a row through a range of columns: Merge A6:H6 Merge J6:N6 Merge P6:S6 Then repeat the above for every 4th row for their respective cells. Therefore i end up with A10:H10 merged etc etc at the moment i...

Hello. As I stated in my title I need VBA code to perform something like this: example. Sheet1 (copy non empty values into Sheet2) <tbody> A B 1 2 3 3 6 4 8 5 14 6 </tbody> Sheet 2 <tbody> A B 1 2 6 3 9 4 12 5 </tbody> Sheet 2 (after macro run)...

VBA: Get an unique list in a new sheet named "unique" in a column. Data is in multiple sheets in each cell. Some sheets, rows, columns or cells may be empty. VBA will not work in sheet named "data1" and "data2". VBA will not override if data exists in "unique" sheet.

Hello, Hopefully some of the experts here will be able to help me with my problem. I wrote a simple macro to check a cell for font with a strikethrough and could not figure out why it kept coming back as false even when visibly, the text had a strikethrough. I took a look at the format cells...

Hi there I have some images which I want to show in userform...so far to show Graph in userform I'm using Set CurrentChart = Sheets("Sheet1").ChartObjects(1).Chart Fname = ThisWorkbook.Path & "\temp.gif" CurrentChart.Export FileName:=Fname, FilterName:="GIF" I was wondering can...

Hi there I'm using userform for my Daily Routine with minimize button with following code Private Declare Function FindWindowA Lib "user32" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function GetWindowLongA Lib "user32" _ (ByVal hWnd As Long, ByVal...