Excel

[chandra amgain]

I have one Excel Question,
i have one excel file in location C:\Users\Chandra\Desktop\Main File.Xlsx and this is my main file. All information include in this file for eg: Main File.Xlsx, Sheet Name "Detail"
And i have one summery File C:\Users\Chandra\Desktop\Summery File.Xlsx. Summery Sheet
what i want when i update something "Main File, Detail Sheet" it need to be update automatic in "Summery File, Summery Sheet". but i need only A, B, C, F, N column value from "Main file, Detail Sheet" need be update in "Summery File, Summery Sheet A, B, C, D, E.
i dont know my question is clear or not

Please Help Me, I hope someone has this answer.
Thank in advance.

 

[kumar lama]

aa

 

[brenner]

two lines need to be fixed
first: LastRowDetailFile = wb2.Sheets("Detail").Cells(1048576, 1).End(xlup)


second: the line below doesn't work for a few reason. 1) you should probably have title in your summary sheet otherwise it will just write the values from the other sheet without a heading. 2) you don't have any values already in there so the code doesn't know where to start. you could either put a single line of summary detail in for the first item or revise the line below to handle a case where it's blank

LastValue = wb1.Sheets("Summary Sheet").Cells(1, 1).End(xlDown)

 

[kumar lama]

Mr. brenner

i tried all way that you gave me, but it still doesn't work so i think i better give you my rough file. please try once.
http://www.filedropper.com/roughfile
Thank you