Hi all
Is it possible to combine two chart into one chart in excel, What I mean is if I have below data:-
WW-----A-----------B
01-------400-------80
02-------550-------75
03------680--------125
04------475--------95

currently I have two chart showing the data, what I want is to have two chart into one which
content
Y axis start from 300 to 800
another y axis start from 0 to 250
and only one X axis which is my ww...

Hi
I have two ranges in my worksheet
One range is called From and contains a date
and the other range is called To and contains a date.
I'm trying to combine the two ranges into one cell on a different worksheet
and I get the number format of the dates instead of the dates taht are shown
in the ranges.

Here is the formula I'm using to combine the dates into one cell
=From&" - "&To
And.. here's the answer I'm getting:
37987 - 38353

How do I get these numbers to show as dates (like 1/1/2004 to 1/1/2005)
I have the cell formated to show as a date..but no luck..

Hi! I'm using Excel 2000, trying to combine two worksheets into one with totals. Each worksheet is for a month (Jan
and Feb), and has a column across the top with defect codes, and the rows contain part info, along with totals for each
defect. I need to make a yearly worksheet that combines the defect totals on each sheet. However, the parts information and
the defects on each worksheet are slightly different (one sheet has more parts and defect codes). I'm at my wit's
end trying to think of how to do this - can anyone help!?!?!

I want to combine two worksheets into one summary worksheet so I can create a
pivot table to chart dates along x-axis and numbers y-axis, legends being
Open and Closed. My worksheet 1 consists of 2007 data and my second
worksheet consists of 2008 data. They have same labels.

i am using this macro
Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add ' add a sheet in first place
Sheets(1).Name = "Combined"
For J = 2 To Sheets.Count ' from sheet 2 to last sheet
With Sheets(J).UsedRange
'Copy heading(1st row) only from Sheets(2)
' otherwise, copy from 2nd row
.Resize(.Rows.Count - IIf(J = 2, 1, 0)).Offset(IIf(J = 2, 1, 0)).Copy _
Sheets(1).Range("A65536").End(xlUp)(3)
End With
Next
End Sub

to move all worsheet into one . it is working 99% good the only thing thats not being transfered to
"COMBINE" is the first line of sheet one only!!! . but everything else on that sheet 1 and the other sheet gets transfered.
can anyone assist me with this problem, or has a better macro to accomplish this task.

Using Excel 2003. I have two Excel files, each with a single worksheet
containing the data that I need to summarize. Each has a common field
containing an account number. I need to summarize data from each spreadsheet
into a single table. For example, I have account number, customer name, city
and state in one worksheet/file and dollar amounts on about 10% of those
customers in the other worksheet/file. Is it possible to combine this data
into a single Pivot Table from the two files? Or do I need to combine the
files into a single worksheet first and go from there? I am new to working
with Pivot Tables and do not know all the ins and outs of the feature.
Thanks for any help you can provide!

I have a spreadsheet with formulas that calculates
percentages and rankings. My boss wants to combine two
formulas into one. He wants to see the percentage and the
rank of that cell on the same line. Is there a way to
combine two different formulas into one?

I need to find out if there is a macro that can help me merge data in 400 cells into one, with the data being separated by a
"; ". Let's say that these cells each contain 4 digits and the range is A1:A400. Thank you for any and all help
in advance.

Using Excel 2003. I have two Excel files, each with a single worksheet
containing the data that I need to summarize. Each has a common field
containing an account number. I need to summarize data from each spreadsheet
into a single table. For example, I have account number, customer name, city
and state in one worksheet/file and dollar amounts on about 10% of those
customers in the other worksheet/file. Is it possible to combine this data
into a single Pivot Table from the two files? Or do I need to combine the
files into a single worksheet first and go from there? I am new to working
with Pivot Tables and do not know all the ins and outs of the feature.
Thanks for any help you can provide!

I have a sample excel file that I'm trying to combine two formuals into one,
taking a two step process into one. In Column A I have a number, like an account number that can be 5 digits or it can be
16. For example in A1 I have: 55556. What I have in cell B1 is

This removes the last digit, returning 5555 in cell B1. In C1 I have:

, returning 000000000005555 (a 15 digit number).

Is there a way to combine these two formuals into one so I can
have the 15 digit text in B1? Thanks for you help and thoughts!!!! Again, best wishes to all in 2011!!!!

I am working with excel and dealing with multiple spreadsheets. I am
configuring data for By Company Total, then into By Rep Total and now into By
Region Total. I have a region called CN. Within CN are are two reps and I
need to combine their data into one CN instead of CN1 and CN2. I am unsure as
to how to do this without messing up all the other data. I started to work on
it, but I think my way will take way too long and I figure there has got to
be an easier way. Could someone please assist me?

I am having some issues with cell formatting getting all messed up when combining cells. I am combining two cells into one
with the below code:

Cell AB are zip codes, and AC is a country. My problem is when I have a zip code that starts with zero, for example
AB450="07522" and AC450="USA", when they are combined it shows up as "7522 USA", I need it to
show "07522 USA".

I have cell AB450 formatted with NumberFormat = "00000", so when it is in
AB450 it shows up with the zero in front. I am not sure how to select the specific data that I am combining in order to
format it to keep the zero.

I am thinking I need something like the below code inserted, but I'm stuck.

I run into a problem on try to match 2 formula into one column, as I am trying to put in 2 difference brand product in to
excel, as I try to sort out the brand of product quickly, I try to use the formula on common Letters on the serial no. and
automatic input which brand name for me. and the formula I using is

Hi everyone, it is my first post. Hope to find new way to learn Excel again.
In my work I need sometime to combine two column into one, but it is various location of column. Find somewhere on net macro
that can do this but only first two column.

I am wanting to have a macro take approx. 200 Excel workbooks and
append them all into one workbook.

Facts:
* I have 200 workbooks each with it's own unique name. 1.xls,
2.xls, 3.xls, ... 200.xls.
* Each workbook contains only 1 worksheet
* Each workbook contains the same 4 column headings
* Workbooks all have different amount or rows
* Looking to combine everything regardless of duplicates into one
large workbook with the same 4 column headings.

Can anyone provide some newbie VBA code/Macro which could faster
then
the old "cut and paste" method.

I am trying to combine multiple rows into one cell in a quick way and I'm not sure this is something that will be easy to do.
I know about Concatenate, but it's not really what I want. . .

Here's what we're doing. I'm a software tester
and whenever I make entries into our reservations system, I log everything to a log file. We can log to .txt or .xls but it's
essentially text so every line goes one by one by one into Excel.

We generally have to take that log file and
cut/paste the responses to the entries into Excel. The responses could be just a couple lines long or they could be several.
And, it is formatted in such a way that Excel (if you save the file as .xls) reads each line as on entry.

Is
there a way to select a range of a response, and put it into one cell? The only way I've found to do this is to highlight the
range, CUT it and paste it into notepad, then highlight and cut it and paste it back into one cell and let the cell resize
the information.