Recent content by lickity40

PH, THAT was it! Thanks to you AND Bob! I hope this does it. I did find one issue that I might be able to work out. I need an exception to this rule for the name "Total". There are a few labels with totals and they are carrying over. Outstanding! Rick

Thank you Bob, On the surface, this makes sense to me. When I run it though, I get the error message, "Run-time error '424': Object Required. When I debug, here is what is highlighted: ===> Sheets("Sheet2").Cells(rw2.cl) = Sheets("Sheet1").Cells(rw1, cl) I verified the names of the...

Algorithmically? I'm thinking that's a programmer's term. <g> Great...so I must be 'thinking' like a programmer to have understood that. Just can't write it out. Tried in my above example but guess it had too much English lol Hmm...Ok. Data table def's. Sheet 1. (that's really the name...

Thanks Bob! Ok..I understand the English part. <g> Again, I'm not a programmer. I got roped into this one but did learn a lot over the past week. It sounds like you're saying to refer to my data source sheet, "Sheet 1". You're identifying the range of source data to examine. Am I on the...

Hello and forgive my jumping into this thread without an answer, but I have a very similar situation. I too have linked to a db table successfully and it is Sheet 1. My Sheet 2 is a template copy of the remaining sheets that has vlookup formulas that brings the data over that is sorted...