Pls help.. urgent

srinivasan1129

New Member
Joined
Apr 20, 2011
Messages
13
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

New Member
Joined
Apr 20, 2011
Messages
13
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

New Member
Joined
Apr 20, 2011
Messages
13
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,493
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Mar 17, 2011
Messages
556
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?
 
Last edited:

Desu Nota from Columbus

Well-known Member
Joined
Mar 17, 2011
Messages
556
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.

Code:
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
 
Last edited:

Forum statistics

Threads
1,082,283
Messages
5,364,268
Members
400,787
Latest member
bs04c

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top