Search results for query: *

p.s and copy cell c from sheet master in sheet jj at cell a in sheet kk c will be copy in cell a, f in b etc

and then to change this code: Sub CopyNrInreg() Dim r As Range, lRow As Long ' Dim sSheet As String ' Application.ScreenUpdating = False With Sheets("Master") For Each r In .Range(.Cells(2, "O"), .Cells(2, "O").End(xlDown)) ' sSheet = Left(r.Value, 2) Select Case sSheet Case "dd", "ee", "ff"...

Sorry but i have another ideea. Can you make this code : Sub CopyDateClient() Dim r As Range, lRow As Long, iCol As Integer Application.ScreenUpdating = False With Sheets("Master") For Each r In .Range(.Cells(2, "E"), .Cells(2, "E").End(xlDown)) With...

Not really. sorry i said my English is bad.

http://dl.transfer.ro/transfer_ro-24jan-c90287e19391b.zip here is my file it does't work realy...:((

Sub CopyNrInreg() Dim r As Range, lRow As Long Application.ScreenUpdating = False With Sheets("Master") For Each r In .Range(.Cells(2, "O"), .Cells(2, "O").End(xlDown)) With Sheets(Left(r.Value, 2)) With .UsedRange.CurrentRegion...

the activecell is o2 in the sheet master.

thanks very much! goes well What about this code: Sub CopyNrInreg() Application.ScreenUpdating = False Sheets("Master").Select Select Case ActiveCell.Value Case "dd" Sheets("dd").Range("A65536").End(xlUp).Offset(1, 0).Value = ActiveCell.Offset(0, -12).Value Application.Goto...

This is the macro 2: Sub CopyDateClient() Application.ScreenUpdating = False Sheets("Master").Select Select Case ActiveCell.Value Case "aa" Sheets("kk").Range("b65536").End(xlUp).Offset(1, 0).Value = ActiveCell.Offset(0, 1).Value Sheets("kk").Range("c65536").End(xlUp).Offset(1, 0).Value =...

Sorry but I don't speak English very well. I have 2 macros. Macro 1 named CopyNrInreg and Macro 2 named CopyDateClient. The first macro"CopyNrInreg", copys the value of column C from the sheet named Master into another sheet; the sheet that will be active depends on the value of column O, you...

I have attached extra rudimentary of my attempt to solve what I need. I want to do the following things with this excel: 1.macroul copydateclient, to copy data (F2: l2) from sheet master if e2 meets one of three conditions: E2 = aa or bb or cc, in Sheet kk at b2:h2, and after that the data will...