×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Joining excel columns after each other

Joining excel columns after each other

Joining excel columns after each other

(OP)
Hi,

I have several excelfiles containing data in column A and B.

I would like to have a vbs script joining all of them in a summary file, so that first file goes into column A and B. Next excel file column go into C and D and so on.

Thankful for any help

RE: Joining excel columns after each other

Hi,

Welcome to Tek-Tips.

Can you explain how joining data from several Excel workbooks in the way you describe is a useful summary? And how will this summary be used?

How many workbooks are there?

Does your data in columns A & B have headings?

Do all the workbooks contain the same number of rows of data?

Is the data is these various workbooks related in some way?

Can you post a small sample of the data from each of these workbooks?

Do you want this summary data in a new workbook?

Is there a reason that you need to preform this task via VBScript rather than in Excel using VBA?

What code have you generated so far?

Please provide an answer to each of these questions.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Joining excel columns after each other

(OP)
Hi and thank you!

The purpose of joining the data is of prep-work character, and will be used in another program. My job is to provide the data from my system.

The number of workbooks is 13 and they all have headings.

Column A and B in each separate workbook are all related where "Date" is in col A and "value" is in col B.

The workbooks contain the same number of rows and follow the number of workdays there is in a month.

Sample would be

Date Value
YYYYMMDD 100
YYYYMMDD 101
YYYYMMDD 103

The summary should be in a new workbook, yes.

The reason why i want it in VBS is because I can use the taskscheduler to run it at any time depending on when the workbooks are created.

I dont have any code so far. Ive been looking at some code where they are joining excel files using the same columns.

Thank you

RE: Joining excel columns after each other

So you're looking for a turnkey solution? A freebie?

You're going to need to do some of the heavy lifting. If you cannot code, then you're in over your head. You'll get some really good TIPS here, but not if your expecting someone else to do all the work.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Joining excel columns after each other

(OP)
If you dont wanna help thats fine. Nobody is holding a gun to your head. rednose

RE: Joining excel columns after each other

I'll help anyone who puts in some effort.

Your move.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close