Search : in
By :

VB code for copy data from one excel sheet to

Last answer on Aug 25, 2009 5:38:54 am BST Himanshu, on Oct 13, 2008 6:28:37 am BST 
 Report this message to moderators

Hello,All

I have one problem Please give me Solution Plese.I have 20 diffrent sheet with same format and i have one more sheet with diffrent format Now,I want to Copy 2 Column to othet sheet rows .How can i do automatically?????

Example

Sheet-1

col1 col2 col3 colm4

1 1
2 2
3 3
4 4
5 5


Sheet-2

Col-1 Col-2 Col-3 Col-4 col-5 col-6 col-7 col-8
Raw-1 1 1 2 2 3 3
Raw-2
Raw-3


I want like this automatically.




Please help

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « VB code for copy data from one excel sheet to » in :
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Ask your question Reply

1

Peter, on Jan 10, 2009 8:50:21 pm GMT
  • +14

Hello,
Your example is not very clear. Do you mean you want to transpose the data from a horizontal position to
a vertical position. If you want to transpose the rows to colums just use copy and paste special.. Make sure you
mark the transpose option in the pop-up window.

Greetings,

Peter

   
Reply to Peter

3

Masoud, on Feb 20, 2009 1:21:08 pm GMT
  • +1

Hi my friend !
I want to write program with Visual basic.
How can I store some data form V.basic to execl file?
tanks you.

   
Reply to Masoud

2

Misu, on Feb 3, 2009 12:59:55 pm GMT
  • +28

Hi,

I have a similar issue like the previous guy, but let me explain a bit:

I have an excel with 50 sheets with the same format. I want to centralize some of the data in a main sheet. For example I want in my main sheet to have on column A the data from cell B50 from each other sheet. I can do this with =sheet1!B53; =sheet2!B53 �.. but this is not the best solution. I�m looking to define the data only for one sheet and then copy for the others (like with �$� when you block a cell)

Thank you,
Mihai

   
Reply to Misu

5

way2ashish, on Apr 23, 2009 6:33:57 am BST
  • +19

Hi i also have a similar problem.
I have data in the same format in multiple excel sheets. I wish to consolidate the data in one new excel sheet..

I wish to automate the process so that at one click all the data from one excels in transported to one excel..

If u have found out the solution , please let me know

   
Reply to way2ashish

10

 Ramesh, on Aug 25, 2009 5:38:54 am BST
  • +1

I have same problem, want to copy all cells of all sheets in one file in raws...

please guide

Gadhvi
rgadhvi@gmail.com

   
Reply to Ramesh

4

jack, on Feb 28, 2009 3:12:45 pm GMT
  • +1

How can i boot .... i dont know how to boot can you help me to the instruction

   
Reply to jack

6

PREE, on May 16, 2009 1:01:14 pm BST
  • +5

Dear Sir..


Plz tell me how to make data sheet of account maintance for office use onlt ,its urgent. and balabce sheet of account. plz couls you fevaour me



pree.......

   
Reply to PREE

7

JOE, on Jun 25, 2009 7:42:15 am BST
  • +1

Hey, i have 1 problem any1 can help me ?
i have 2 sheet. e.g 1 sheet: name , lastname
2 sheet: want to get lastname in 2 sheet

   
Reply to JOE

8

Paran, on Jul 1, 2009 7:00:58 am BST
  • +4

This is very simple

go to sheet 2 click = and come to sheet 1 and keep on the cell which wants to reflect on sheet 2 and click enter

   
Reply to Paran

9

Raji, on Jul 28, 2009 9:06:37 am BST
  • +6

If same has to be done by coding means how to do? What is the coding?

   
Reply to Raji
Ask your question Reply
They need your help