excel 10

Hi Friends, I have 10,000 rows and unlimited data in columns. Two parameters in adjacent columns and are repeating after 13 unwanted columns. I want to concatenate these adjacent columns of a row separated by space eg: concatenate(B2,C2,"",P2,Q2,"",AC,AD,"",....) But I dont know upto which...

I have a workbook that HAS to run excel 2003 because of 2010 not being able to import the proper file extension any longer. I have an excel menu with a lot of hyperlinks to different workbooks that run fine on 2010. I need a code to open an excel 2003 file within excel 2003 when either a...

I am trying to change the columns of a Waterfall chart from bars to an arrow. I know how to accomplish this in Excel but I need to make this happen for the user with VBA. The macro recorder does not work when modifying charts in Excel so I cannot find the code to create a pictograph there or...

hi im conducting a stock count. Column A consists of a list of the barcodes I've scanned. in column A there is sometimes more than one of the same barcode when i have more than one of the same product. is there a way of deleting duplicate barcodes in column a and replace them with a 'Quantity'...

Hi, In Excel 2010 I have a macro button on my Quick access tool bar to run the below code: Sub DataPrep() Dim finalrow As Long finalrow = Cells(Rows.Count, 1).End(xlUp).Row Columns("A:A").Select Selection.Insert Shift:=xlToRight Range("A1").Select...

Hi everybody! First off, I'd like to thank all of you for this incredible forum... it has helped me countless times in my work life!! I have a simple pivot table with a few calculated fields. When I add the calculated fields to the pivot table, two issues occur: The caption is renamed: Sum...

Is there a way that i can compare multiple sheets in a graph. I am trying to graph totals from 5 different sheets all the totals I am trying to do graph are in the same cell on all the sheets

I enter customer details onto an excel 2010 spreadsheet, ie customer name, date, description of order, amount of order etc. Sometimes, under certain criteria, the same or part of the same information needs to be added to another tab, ie tab2, on the same spreadsheet. I wanted to create an...

Hello, I'm new to VBA and the board so I'm sorry if I'm unable to explain myself very well or if I've posted this in the wrong place. I have been trying to create a function with the "if then statement" to calulate the cost of a produce all with differing angles, finish, pipe size and product...

Hi all Im not sure if this is a basic math question but I'm scratching my head over it. Basically, I have been given some data relating to the seasonality of sales discounts to mess around with. I have managed to calculate the average discount for the year based on those trends without any...

:eeek:hi i would be greatful for your help, i have an excel 2010 worksheet with the details of my karaoke tracks( artist track etc) the tracks themselves are numbered ZM00001..2..3 etc these details are also in the excel doc. I know i can use a hyperlink to just click and go...the problem i...

I use a weekly tracker of all our sales reps' call rates, conditionally formatting the call rate averages in a traffic light system of red,amber, green depending on if weekly targets are met. Halfway through the year, the target call rate went up from 3 to 4 mid year. How do i change the...

I need a column chart which trends 6 month(I have this covered) but stretches rows based on values in the data set. I could hook the chart to the pivot BUT I need to summarize all values over a count of 5. so, if you have 4 values, then just who 4 (3,2,1) BUT if you have 12 values then show the...

I found this VBA code and I'm trying to implement it in Project 2010 but it keeps coming up with an Overflow Error. I highlighted the problem line 'set some global variables Dim iter As Integer Dim exportedTasks, monteCarloTasks As Tasks Dim myCancel As Boolean Sub Blackjack() 'A simple monte...

Most of the font and cell colors that I used regularly in Excel 2003 are no longer standard in 2010. I can see how to create them in the customize window, but that is a lot of work to do all the time. Is there a way to create them once and have it save so that every time I open Excel the colors...

how can can i stack multiple work sheets into a master work sheet in one work book? i know it will require vba but i am new to it and any i have downloaded does not seem to work i use excel 2010

In Microsoft Excel 2010 how can you get a web query to refresh into the next column instead of the same cell? I'm trying to track the price of a share of stock by date and would like the fields to update themselves every single day. I've tried different things including writing out a seemingly...

In Excel 10 I am currently using a short cut key (ctrl+i) that triggers a macro located in workbook A to open workbook B (which is a true template although it can be a regular workbook - I'm not opposed to that). Workbook B has an Auto_Open macro that asks the user to name the workbook via a...

Hi All, Am working on some vba to essentially create a Word document. I've gotten fairly proficient with VBA in the confines of MS Excel and know little to nothing about how to make it work inside of a word document. I've managed to get a new document to open and text on the page. The...

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> I am trying to link a Excel (97-2003 or 2010) spreadsheet to a Quick Test Pro test so I can write out test step status. While I can insert rows in a database table, I have been instructed to...