exce

I need to combine two pivot tables into one. both are in same worksheet. Any help?? Thank:confused::confused::confused::confused: You

Sub lkup() Dim rng As String rng = Range("A1", Range("A1").End(xlToRight).End(xlDown)).Select Dim count As Integer count = Application.WorksheetFunction.Match("City", Sheets("carrierresponse_list").Rows(1), 0) MsgBox count Range("B2") = WorksheetFunction.VLookup(Range("A2").Value...

In Excel, if the text in an column is longer than the width of the column and there is no text to the cell to the right, it will overlap into that cell on the display. Is there an option for a ListBox to work the same way. I am displaying an indented structure and intentionally want the column...

Hi everyone. I have a spreadsheet that has a name, address, postal code and some figures that I need to put into a standard letter. It is just one record i.e. one person, and one set of prices that go into the letter (which is a quote). I'll call the spreadsheet "Costs" and the word document...

Hi, I'm unable to give different colour for the text inside the chart. When i tried its getting changed for all the text present inside the chart. The scenario here is my chart has 2 bars one is named "YES" and other one is "NO". I want the yes to be in colour Red and no to be in colour Green...

Hello! I have some VBA that generates an email that includes an HTML table, into which some values (defined as integer variables in the VBA) are put. I was wondering if there is a way to format the numbers to appear as (#) when they are negative. Here is the code as it is parsed into the HTML...

Hi there! I am fairly new to VBA and brand new to mrexcel.com so please be as detailed as possible in responses (thanks!). My issue: I have a data table called "DataEntry" It has four columns (i.e. fields) - JobType, Rate, Hours, and TotalPayment. JobType is a dropdown list of choices (i.e...

Function countonlynos(countrange As Range) Dim tempcount As Double For Each cell In countrange If IsNumeric(cell.Value) = True And IsEmpty(cell.Value) = False Then tempcount = tempcount + 1 End If Next countonlynos = tempcount End Function

Hello all, Thanks in advance for your help. I have a static folder in which I have saved 20 to 30 text files. I need to get the information in these text files into excel, all into column A, right after the other vertically. Right now I manually open each folder, copy the info, paste it into...

I am trying to pass an argument to a function where the argument is concatenated. it is not working . Can any body help. The function code is ------------------------------------ Function degf(ByRef x As Variant) degf = x * 1.8 + 32 End Function ----------------------------------- Sub...

..

Essentially, I would like to find a way to create 400+ bookmarks in a word document through mail merge or by some process with VBA. I've created a word document with several mail merge fields that create individual pages for U.S. States with some summary information. I need four of these fields...

I need your help! I’ve got many files with data in specific format. My intention is to change these workbooks formatting, without changing inserted values. What I already have is this poor code, that copies values from source workbook and puts them in a new one. Option Explicit Sub MojeM()...

I have this excel file that works as a data base, there i fill everyday 5 tables in 5 different worksheets, each table grows along with the day, so each row is linked to an specific date. Then i need to make a daily report in a powerpoint presentation. I've done the presentation as a template...

Hi all, I have a formula in cells E8:E19, which is driven from a pivot table / slicer. These cells have conditional formatting, 'graded color scale'. Directly to the left of these D8:D19 I have a group of text cells. I require these cells to reflex the formatting of the cell adjacent. i.e. D8...

Hi, I'm trying to hyperlink to a cell in another sheet in the same workbook. I can get the furmula to work, but if I add rows above the targe cell then they Hyperlink formula doesn't automatically adjust. How do I correct for this Below is the example. Sheet1 <tbody> Address Painting...

Hi, i am a newbie to macro and vb programming i want to implement a small functionality of selecting a cell using buttons in a table For E.g in a table like this <tbody> Column Button A Column Button B Column Button C Row Button A 13 14 15 Row Button B 16 17 18 Row Button C 19 20 21...

I have a large workbook, wherein I use UserInterfaceOnly on the sheets implemented through the Workbook_Activate event. Up until now it's always worked just fine, but now it doesn't work in a specific circumstance. When I open the file directly or with a shortcut or with the File->Open...

I currently have an array which I populate and paste in a sheet named "T1" using a macro. my current macro uses the rowcount function to determine the used rows and pastes the array from the next available row. The problem i am having is that when I paste this array multiple times, the arrays...

I have a spreadsheet with information I wan to copy in Columns C through to V. Column V has a number, then lots of blanks then a number, then lots more blanks, then a number...etc. I want to copy the selection from column C to V, starting at the row with a number in column V, down to the row 1...