Hello: How could I combine cell H8 and E10 from the cost accounting Sheet to the Data sheet into one cell from D3 to D13. The code below only pastes E10 into the D3 to D13 range

H8=Name

E10= Address

D3=Name/Address

H8=Name

E10= Address

D3=Name/Address

Sheets("Cost Accounting").Select Range("E10").Select Application.CutCopyMode = False Selection.Copy Sheets("Data").Select Range("D3:D13").Select ActiveSheet.PasteThanks

- To combine two chart into one..
- Date formatting when combining two cells into one
- Combining two worksheets into one
- Combine two worksheets into one summary worksheet
- Macro to copy two cells into one
- Macro to combine all sheet into one
- Is it possible to combine two worsheets into one Pivot Table?
- Combine two formulas in one cell
- Macro to merge 400 cells into one with a "; " separator
- Is it possible to combine two worsheets into one Pivot Table?
- Combining two formuals in one cell.
- Combine multiple cells into one cell range.
- Combine Multiple Cells into One Based on another Cell
- Combining two cells, losing formats
- Combining two cells into one value?
- How to combine 2 sheets into one sheet
- How to combine 2 formula into one column
- Combine two formulas into one cell
- Combining two cells with into one
- How to combine two columns into one but on different rows?
- Two selected column into one fix
- Need Macro to combine multiple workbooks into one
- Macro To Combine Multiple Cells Into 1 With Other Characters
- Combining multiple rows into one cell

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...

Pls comment and help on this tks...

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..

Thanks in advance for your help!!

Kimberly

Thank you!

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 need a macro to copy both of them into a new cell of another sheet, let's say Sheet2!C1, and display it as 7&8.

Is it possible?

Thanks a lot!

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.

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!

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?

Thanks for the help.

T.R.

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!!!!

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 have a two columns of data:

A|B

0.a|1

0.a|2

0.a|3

I need

A|B

0.a|1

|2 (same cell as 1, but alt+enter down)

|3 (same cell as 1, but all+enter down)

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.????("????").Select Selection.NumberFormat = "00000"

Example,

AAA111 BBB222I need the resulting new column value to be;

AAA111_BBB222

Is there any easy way to do this?

Thank you,

pls help my. how to combine 2 sheets into one sheet. Example below :

sheet1:

A B C

1 1 1

2 2 2

sheet2 :

D E F

1 2 3

3 2 1

sheet3(result) :

A B C D E F

1 1 1 1 2 3

2 2 2 3 2 1

Thanks..

HP

=INDEX(Lookup!$A$2:$F$50,MATCH(MID($C4,1,3),Lookup !$A$2:$A$50,0),2)

Dell

=INDEX(Lookup!$A$2:$F$50,MATCH(MID($C4,5,3),Lookup !$A$2:$A$50,0),2)

is there anyway to combine both formula into one column?

and I am looking for something like

HP "OR" Dell as result.

any help would be thankful

Nick Yee

=CONCATENATE("TEXT")

=LEFT(B2,FIND(" ",B2)-1)

So the first word in another cell inserts after the text in the cell.

Any help would very much be appreciated. Thanks.

A1 Tom

A2 Bell

I want to combine this info into one cell to show it as A2 Tom Bell

??

I have an annoying problem I can use some help one.

I have a worksheet with two columns (A and B), one is files names and one is path.

I want to combine these into one column but not as A+B.. it needs to be:

A1 = filename1

A2 = Path to filename1

A3 = filename2

A4 = Path to filename2

etc.

(there are several thousand rows otherwise i would just do it manually.)

thanks!

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.

Sub AA()

Columns(3).Insert

Set rng = Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp))

rng.Offset(0, 2).Formula = "=a1&""""&b1"

rng.Offset(0, 2).Formula = rng.Offset(0, 2).Value

rng.Resize(, 2).EntireColumn.Delete

End Sub Can somebody help me redo it to combine two selected columns into one with space between values and second column deleted?

Thank you.

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.

Thanks!

Included in the newsample.xls file I have a table A1:W25 which is my starting point. I then run a macro called "Restructure" and it changes the data into a table that looks like X1:AS5

What I need is help modifiying the macro to include the values of the cells at the end of the assignment name. See a partially complete table in X7:AB8

Thanks in advance!

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.

I appreciate your help!

Thanks,

Chris

No luck finding an answer? You could always try Google.