5.copy

Hello - I am studying VBA language. I am stuck. I want data from each of these sheets to be copied to the IMPROPER DETAIL tab but I can't get it to work. Can you tell me what I am missing? Sub updatedatafromsheets() Dim LoopCounter As Integer Dim NumberOfWorksheets As Integer Dim lastrow As...

Hi guys, Im just starting with VBA. could you help me and tell how I can do this operation with a loop. Now Im changing the offset values manually but I know there is a loop possible. Could you please tell me how to do it with explanation. Sub iex() Dim i As Integer Dim y As Integer...

Hi all, I'm a bit of a rookie and can't figure out how to add another IF to this code below. Sheets("CORE").Range("A1") is referring to a date.. and if that date can't be found in the ActiveSheet.Range("A1:A100"), I would like it to do nothing, no next. I would also like to not use...

I get an error "Application-defined or object-defined error" when running this code. It works fine if copied to the same workbook. The culprit is ("C" & Rows.Count). What am I doing wrong? Any help would be much appreciated, thanks. Range("AB1").Resize(1, 5).Copy...