hello
What macro can I use to copy and paste lines above 0 from yellow areas to "check data"
I just want to copy and paste in value for client 1 to 12 without total result
thank you
hello
What macro can I use to copy and paste lines above 0 from yellow areas to "check data"
I just want to copy and paste in value for client 1 to 12 without total result
thank you
Last edited by bast0504; 05-06-2013 at 02:57 PM.
You need to change the source range shown in blueSub Test() Dim LastRow As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row + 1 Range("E" & LastRow & ":P" & LastRow).Value = Range("E7:P7").Value 'Range("E7:P7").clearcontents End Sub
Elegant Simplicity............. Not Always
Hi anylitch
I don't understand your vba code, i want to copy yellow zone for "variable", "fixe", "Mark" sheets and past lines above 0 in "check data" sheet in green zone.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks