excel 10

<COLGROUP><COL style="WIDTH: 48pt" span=26 width=64><TBODY> 1007A1 VTC VLB9 a b c d g h i j k 2011 0 0 0 0 0 0 0 0 0 0 0 0 </TBODY> Hi i need the above sheet to be converted into following format in another sheet:confused: <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> 1007A1 VTC...

I have created a custom theme and for some reason when I send the file to someone who doesn't have it the theme reverts to the default. I never had this problem with 2007 and only recently switched to 2010. Is it a setting in office 2010 that I can change?

Excel.Application.Interactive = False, prevents excel from accessing it. But this property is not working in windows7. In XP, open excel VBA. Try the following code snippet in a button click, Excel.Application.WindowState = xlMinimized Excel.Application.Interactive = False This will...

While running one of my application, excel will be opened at the middle. I need to minimize the excel and stop interacting with it, which means even if I click the excel task bar it should not open excel. It should be always in minimized state. I have an code which works in XP and is not...

=VLOOKUP($A$3, 'SAP Data'!$A$3:$A$7,1,FALSE,INDEX('SAP Data'!$AL$3:$AL$4805,SMALL(IF('SAP Data'!$AK$3:$AK$4805>=H3,IF('SAP Data'!$AK$3:$AK$4805<=N3,ROW('SAP Data'!$AL$3:$AL$4805)-ROW('SAP Data'!$AL$3)+1)),ROWS(H$3:H3)))) The above is the formula I'm using, just a little long. I'm using...

Question: I have two sheets named Sheet1 and Sheet2. Sheets looks like this: Sheet1 A ab@gmail.com je@yahoo.com gy@hotmail.com ob@outlook.com vh@hotmail.com nk@ymail.com Sheet2 A ob@outlook.com je@yahoo.com nk@ymail.com Here is what I want: If any cell in Sheet2 Column A = Any cell in...

Hello I have never tried to do anything too advanced but I am having to go though a lot of unprocessed information and would really like some help. I have got all information on one line and the line below it the email address of my client. I need all this information to appear on one line...

Hi - I'm a newbie here so apologies if my answer is to be found somwhere already. Excel 2010 conditional formatting - I want use conditional formatting using icon sets, however, I need to use my own graphics instead of the arrows, flags and other shapes available in the existing icon sets. Is...

Hi there, I have a macro (code below) that is assigned to a button in an Excel 2010 Macro Enabled Template (.xlsm). I push the button and it copies a pre-formatted row from one worksheet to another and pastes it beneath a row with a specified value in a column. Option Explicit Sub...

Hello! I have a quite big database as a result of a study in Excel 2010. There is a special block of data for every participant in the study, including 16 data series in 16 lines. I have to make a unique chart for every line. One block is bulid up in a way, that every row is the input for a...

I have six worksheets in sequence from "July to Dec". In each worksheet I have data enetered into the cell A1 The following formula works fine =SUM(July:Dec!A1) to sum all the A1 cells at all worksheets How do I use an indirect reference to two different cells; so I can change the start and...

Hello, I am working on a Excel document, and I am trying to copy data over that have a value to sheet. For Example, I have 7 colums starting from B3 to H3, and what I am trying to do is copy the rows based on location to that sheet. Each sheet will be named by location so for example...

My spreadsheet has a list of customers and invoice amounts and a yes or no that indicates whether or not they have paid. I want to sum only the amounts that have been marked as a yes (for paid.) I tried using the sumif function but it didn't work correctly. My next idea was to do an imbedded...

Hello all. As always, thanks for this repository of knowledge and experience. I manage a growing retail firm that has recently expanded from a single-location to two locations and a separate warehouse. Initally I was tasked with developing a Point of Sale system that would track our inventory...

I have created a chart that provides a hisotry of events on a timeline. It relies on named ranges and allows me to change the upper and lower date ranges displayed on the x-axis of the chart by changing the date in cells that define the upper and lower dates. In order to display the events on...

I'm making a program for a Photography company to help them keep track of theres invoices. On the Invoice sheet, after an invoice is completed, I want to select certain cells and have them posted in the Records sheet. I tried recording a basic macro but every time I run it, it replaces the...

Hi, I have 2 columns of data - a list of text names and a list of the number of times they occur, like this example: Name ___Coverage cds a ___3 cds b ___2 cds c ___1 cds d ___0 cds e ___2 I'd like to get to a point where I have each text name represented the corresponding no. of times...

:confused: I am attempting to use a CONCATENATE formula to conver Bytes to KB but I am having trouble. I hope someone can help me. Here is my example: A1 B1 D1 File.txt 6,356,388 6207.41015625 KB I want it to return as 6,208 KB Here is my formula: =CONCATENATE((B1/1024)," ","KB") Anyone...

I'm very familiar with pivot tables, slicers and dashboarding, but looking for some guidance regarding data source setup and configuration. Our data sources are updated daily, and I'd like to know the best way to connect slicers to the data source to use 'refreshed'/updated data... currently we...

ok i am working on this this excel program and i have just about finished it, but i cant for the life of me figure out how to make a range of number EX(0-100) to apear in a cell in that format. I am trying to calculate the BMI of people. Now the BMI has a range in itself. Like it goes up to 18.4...