Excel guru's Please help..

[smartguy]

Hi all,

I have 20 sheet in the Excel file. in the below Format.

i want collate all the sheet in to 1 sheet.

Excel Workbook
	A	B	C	D	E	F
1	country	movie	movie	therate	suma	time
2	usa	aaa	aa	a	a	a
3	usa	aaa	aa	a	a	a
4	usa	aaa	aa	a	a	a
5	usa	aaa	aa	a	a	a
6	usa	aaa	aa	a	a	a
7	usa	aaa	aa	a	a	a
8	usa	aaa	aa	a	a	a
9	usa	aaa	aa	a	a	a
Sheet1

 

[smartguy]

Error 400

 

[smartguy]

Error 400...

Please help....

 

[Krishnakumar]

Hi,

Until and unless if you provide more info about the error, you won't get any reply here. They both asked you to provide in which line you get the error.

Post your code here and tell us in which line you get the error.

 

[sanrv1f]

goto the VBE module where you pasted the code,

Press F8 to execute the code line by line, and post the line where you encounter an error

 

[VoG]

You asked me to look at this in your other thread http://www.mrexcel.com/forum/showpost.php?p=2003218&postcount=12

You need to answer the questions that your helpers have asked.

 

[smartguy]

Hello Mr.sanrv1f

Its Working.

Thank you Very much..................

 

[schueyisking]

im bumping this up coz I have the same problem as the original first post, but I can't get it to work?

When I run each line in VB and get to this line:

Worksheets(sh1).Cells(lastrow + 1, 1).PasteSpecial xlPasteValues

I get this error:

'Run-time error 1004': The information cannot be copied and pasted because the copy area and the paste area are not the same size and shape'

Im on excel 2007.
Thanks.

 

[PCL]

Is there any merged cells where you want to copy the data?
Is it happen for the first sheet where to copy?
Did you ever try the second code if there is the same message?

 

[schueyisking]

There are no merged cells no.

I'm not sure what you mean with the other questions, sorry.

Do you have an email so I can send the spreadsheet?
I don't know how to program.

 

[sanrv1f]

did your data exceed more than 1 million rows?