Hi There,
I have a worksheet that collates data from batches in sequence order. For eg: I already have data(Say eg, column A to Z) for batch 1. After batch 2 is succesful I am pullimng data from batch 2 extract file to my worksheet and adding after batch 1 data because order of column is same for all batches.
I have a macro which perfectly do this. But just a section of macro fill formulas in column A, B, J, L amd M and copy data in K column. Below is the code.
bLR = Range("A" & Rows.Count).End(xlUp).Row
lLR = Range("C" & Rows.Count).End(xlUp).Row
Range("A" & bLR & ":B" & bLR).AutoFill Destination:=Range("A" & bLR & ":B" & lLR), Type:=xlFillDefault
Range("J" & bLR).AutoFill Destination:=Range("J" & bLR & ":J" & lLR), Type:=xlFillDefault
Range("K" & bLR).Copy ThisWorkbook.Worksheets("Abslayer_SAP_BCN").Range("K" & Rows.Count).End(xlUp).Offset(1, 0)
Range("L" & bLR & ":M" & bLR).AutoFill Destination:=Range("L" & bLR & ":M" & lLR), Type:=xlFillDefault
Calculate
The below line of code does not copy the data.
Range("K" & bLR).Copy ThisWorkbook.Worksheets("Abslayer_SAP_BCN").Range("K" & Rows.Count).End(xlUp).Offset(1, 0)
Can someone help please?
Thanks,
Su.
Bookmarks