Pls help.. urgent

[srinivasan1129]

Dear Folks,

I have one work book Named " Data sheet" it contains Sheet 1 named "Area" IV columns (say all the columns are filled with Data), Sheet 2 named "Rainfall" it also contains data till IV (i.e. i cannot add more columns as it ask to delete last unfilled data), sheet 3 named "Villages" same here to.. all columns are filled.

Now i need one excel sheet which can display all these 3 sheet (i,e. IV of Sheet 1+ IV of Sheet2+IV of Sheet 3)

Pls help me its urgent

 

[srinivasan1129]

Adding Columns of two sheet into one

Hello fellows,

I have sheet 1 with all coulmns filled. and sheet 2 as same as sheet1.
Now i need to add Sum(a1:a3), Sum (a4:a5) and similarly it moves upto 1163 rows Rows of sheet 1 and same as sheet 2..

i need the sum in new excel file...

pls help me

 

[srinivasan1129]

adding columns fo different worksheet

Hi,

I got sheet1 with columns named
Year - District - Area - Production - Rainfall
2000 - Guntur - 1289 - 324242 - 25
2000 - meenju - 32312- 21312 - 32
2000 - fredir - 23232 - 2224 - 56
2000 - edir - 23423 - 9239 - 44
2001 - Guntur - 1289 - 324242 - 25
2001 - Meenju - 1212 - 34353 - 34
2001 - meenju - 32312- 21312 - 32
2001 - fredir - 23232 - 2224 - 56
2002 - edir - 23423 - 9239 - 44
2002 - Guntur - 1289 - 324242 - 25
2002 - Meenju - 1212 - 34353 - 34
2002 - meenju - 32312- 21312 - 32
2002 - fredir - 23232 - 2224 - 56
2002- edir - 23423 - 9239 - 44.
. . . .
. . . .
. . . .
2009 - edir - 32423 - 33243- 34

In sheet 2, i have
Year - District - temperature - wind - snow
2000 - Guntur - 1289 - 324242 - 25
2000 - meenju - 32312- 21312 - 32
2000 - fredir - 23232 - 2224 - 56
2000 - edir - 23423 - 9239 - 44
2001 - Guntur - 1289 - 324242 - 25
2001 - Meenju - 1212 - 34353 - 34
2001 - meenju - 32312- 21312 - 32
2001 - fredir - 23232 - 2224 - 56
2002 - edir - 23423 - 9239 - 44
2002 - Guntur - 1289 - 324242 - 25
2002 - Meenju - 1212 - 34353 - 34
2002 - meenju - 32312- 21312 - 32
2002 - fredir - 23232 - 2224 - 56
2002- edir - 23423 - 9239 - 44.
.
.
2009 - edir - 32423 -33243- 34


nOW I WANT TO A NEW WORK SHEET WITH THE FOLLOWING COLUMN

YEAR - District - Area - Prod - Rainfall - Temp - Wind - Snow

i dont want to copy/ paste since i got more file on this...

pls need your reply urgent...

 

[Joe4]

It looks like all three of your posts are probably on the same question, so I merged them all into one thread. Let m know if this is not the case.

All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

 

[Desu Nota from Columbus]

Are you familiar with Record a Macro?

You can record yourself doing the copy and paste once (make sure you copy/paste the entire column of interest) and then reuse the macro as needed.


Is the data under Year and District exactly the same and in the same order from sheet 1 and sheet 2?

 

[Desu Nota from Columbus]

Here is a macro you can use as long as the data starts in Column A and all the year and district data is exactly the same from sheet 1 and 2.

Sub CombineData()
   Sheets("Sheet1").Select
Columns("A:E").Select
    Selection.Copy
    Sheets("Sheet3").Select
    ActiveSheet.Paste
    Sheets("Sheet2").Select
    Columns("C:E").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet3").Select
    Range("F1").Select
    ActiveSheet.Paste
    Range("A1").Select
End Sub