PC Review


Reply
Thread Tools Rate Thread

Change code to popualte into cols D,E, & F instead of A,B, & C

 
 
=?Utf-8?B?QlpleWdlcg==?=
Guest
Posts: n/a
 
      30th Oct 2007
I have a macro that gathers information from the second row of other excel
sheets and puts that information all into one file. It inserts that
information into columns A,B, and C of a new excell sheet.

For example:

Folder: C:/test contains numerious excel files that hold infromation in the
first two columns.

When I run the macro, A new sheet is created with the infromation from the
columns populated into the first 3 columns. I would like it populted into
columns D,E, and F.

A B C
1 File1 2007 $1234
2 File2 2007 $5246
3 File3 2007 $2456
4 File4 2007 $299

The Macro Code:

Sub RDB_Merge_Data()
Get_File_Names _
MyPath:="C:\test", _
Subfolders:=False, _
ExtStr:="*.xl*"

If fnum = 0 Then Exit Sub

Get_Data _
FileNameInA:=True, _
PasteAsValues:=True, _
SourceShName:="", _
SourceShIndex:=1, _
SourceRng:="A2:b1", _
StartCell:=""
End Sub

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba code for finding the ranges between 2 cols tom Microsoft Excel Programming 3 4th Jul 2009 10:39 AM
Enhance sub to copy cols of variable length into 1 col to snake results into other cols Max Microsoft Excel Programming 1 7th Aug 2008 02:03 PM
Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error? Craigm Microsoft Excel Programming 2 2nd May 2006 11:04 AM
Cond Format:re color 2 cols, skip 2 cols =?Utf-8?B?VGF0?= Microsoft Excel Worksheet Functions 2 22nd Jun 2005 06:43 PM
Macro to change value 2 cols over from search admlcl@yahoo.com Microsoft Excel Programming 4 27th May 2005 09:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:38 PM.