Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

How to merge multiple worksheets ?

Comment:

I have an excel workbook with approximately 50 worksheets in it. Each sheet is formatted in the exact same way, A1 contains a row header and A2, A3, A4 etc contain the data. For each sheet the data and column heading are different. I need to get all the sheets merged into one so that I end up with a master sheet. I need it to be in the following format, Sheet 1 Colum A contains everything from the first worksheet, Sheet 1 column B contains all the data from sheet 2, Sheet 1 column C the data from sheet 3 etc etc. I've searched far and wide for a solution, but the closest I can get is having all the data from all the worksheets end up in column A, which isn't much use really. Can anyone throw me some vba that'll do this ? many thanks in advance for any help

Need SQL query help.

ASP Programming help need...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Ok so im trying figure out how to do multiple responses, and it is getting confusing and it wont work, so i figured id copy and past what i have, and you could tell me if i was completly wrong, I will...

Summary: Hi, I'm trying to write an script that will replace words by html formated urls with it's anchor text. I tryed using sed like : sed 's/WORD2BEREPLACED/ the url <\/a>/g' document.txt > newdoc.txt S...

Summary: Hi I have 2 text files - Customer1.txt and Customer2.txt. Both files have same data format. i need to merge these 2 files such that data from Customer2.txt is appended to data from Customer1.txt and a...