LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Macro to Create Table

Could you please help me!!!!!!!!!!!!!
I have a excel file "A" located in C:\test\A.xls..This file has the
following information:
Cell(A1) = Work Order
Cell(A2) = Track
Cell(A3) = Date

I want a macro to send this information in the file"B" located in
C:\test\B.xls...but ordered in this way:
Cell(A1) = Work Order
Cell(B1) = Track
Cell(C1) = Name

Then, I want to do this:
Typed again in the file"A"
Cell(A1) = 3000
Cell(A2) = 50
Cell(A3) = John
and see in the file"B"
Cell(A2) = 3000
Cell(B2) = 50
Cell(C2) = John

And so on, so the new information is always taking the empty row.

Could you please provide me the code........

Thankssssssss.

Giovanna.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Record Macro to Create Pivot Table Ken Excel Discussion (Misc queries) 1 April 25th 07 09:42 PM
Can I run a macro to create a pivot table? Eqa Excel Discussion (Misc queries) 2 April 8th 07 06:16 AM
Create a Word Table from a Excel Macro Silvia Excel Discussion (Misc queries) 0 September 7th 06 12:34 AM
Assign a macro to create a pivot table acsugguiyao Excel Programming 2 June 23rd 05 03:04 AM
Macro to create pivot table/ chart Saint Excel Programming 2 July 6th 04 08:29 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"