Copy and Paste Macro

Can you post a little more details ? where is the data entered, what and where are you copying/moving, how big is the selection, etc.

Juan Pablo G.

I work for a travel agency and am making a group spreadsheet. I have a about a 100 individuel conformation worksheets in a file. Also in that file are 4 Summary pages with different details like payments, etc. What I am wanting to do is link a master summary to the 100 worksheets and have the remaining 3 summarys link to info on the master summary. I don't want all 4 summaries linked to the 100 tabs, the workbook would become too big. The macro I would like to make would copy data from the master summary and paste it onto the remaining 3 summarys depending on the value of the data. If the row of data is 0, then I want to skip it and move onto the next line until it has pasted everything in the master summary. I have everything linked up, I just need to make a macro. My biggest problem is that I do not want any row showing up as 0 on the remaining 3 summaries. Maybe I need a macro to hide rows instead. Does that make sense? Any ideas?

I don't know how this option sounds to you, but maybe give Advanced Filter a try (Using copy to somewhere else), you could filter all those < > 0.

Juan Pablo G.