clubbing workbooks without copy paste from each workbook

[ROHAN999]

Sir

i have a folder named as "master sheet"

in it i use to save the workbooks sent by various offices in a similar format

kindly help me by providing me a code which can club all the workbook in a single sheet named as "master" in the said folder "master sheet"

plz help

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[ROHAN999]

done sir

i have changed the title

actually whenever i want to start ..i start with copy from all workbook sheets and paste it in master

[oeldere]

For that question, see the link below.

http://www.excelforum.com/the-water-...-question.html

[ROHAN999]

All right sir,
thanks for your suggestion ,,,

i am just uploading a dummy sample in few seconds

[ROHAN999]

Kindly see the attched sample

row 1 in bold will be same in all sheets at the bigning ,it is a header,under which there is data in each workbook

kindly help to club,,because its too much tedious to copy from each...

[oeldere]

I get an failure when i try to open your file.

please upload another (excel) file.

You are allowed to use macro's for your solution?

[ROHAN999]

Uploading once agian plz c sir

FILE IS IN MS OFFICE 2003 KINDLY UPGRADE IT OR SAY TRUSTED IF ASK

[oeldere]

@Rohan999

I think you don't read the link i provide well enough.

Try again.

[ROHAN999]

Oh i am sorry

now c sir

[ROHAN999]

In the link suggestion to upload a test sample was there so i uploaded

[oeldere]

The link suggest you upload an excel file, in which we can see

how your data looks like

what has to be done

how the results should look like

where the corresponding cells are


And some other advice:

I don't want to open excel file which give me an failure when I try to open it.

I think there are more members thinking that way.

So you get better help if you don't have that problem in you file.

So try to fix it.

[ROHAN999]

Loading two workbooks and final workbook for example

LIKE WORKBOOK1 AND WORKBOOK2 SEVERAL SHEET ARE THERE WITH DIFF NAMES IN MY FOLDER MASTER SHEET

AND I WANT TO UPDATE FINAL SHEET WHICH I HAVE MADE WITH NAME MASTER

ONE MORE REQUEST

THAT SOME OF THEM SEND IT IN MS OFFICE 2003 SO XLS FILE AND SOME IN MS OFFICE 2007 SO XLSX FILES

THE VBA CODE CAN COMBINE ALL IN MASTER

[JBeaucaire]

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.

Looking in the code, you'll also probably want to change the COPY command to start at A2 instead of A1 so it skips the titles.

Please Login or Register  to view this content.

[ROHAN999]

Yes its very useful but i have sls as well as xlsx file both in my folder

[ROHAN999]

Another problem with this code is that,i have a smae header as row one in each..it is copying that too

[JBeaucaire]

This line of code in that macro is designed to detect any files in that folder that have .xls in them, so that would find .xls and .xlsx in the same folder.

Please Login or Register  to view this content.

[JBeaucaire]

Another problem with this code is that,i have a smae header as row one in each..it is copying that too

Sounds to me like you did not make the edit I recommended in post #14.

[ROHAN999]

Ossom..thank you

[ROHAN999]

Sir

sry to mark it as unsolved

my only that has been remaining is that in my master sheet column g should be numbers

whenever i import using vba ,i use to format it manually as number..and everytime this is happening

kindly help a bit more

[JBeaucaire]

Nothing in the macro given is changing the nature of the values copied. Your sample sheets have numbers in column G and thus numbers are copied in column G.

[ROHAN999]

Yhank you very ,much sir..u really helped me alot