May 26, 2019
I have Sheet 1 and Sheet
Sheet 1 => https://paste.pics/6d48d50d545.....e727b44958
Sheet 2 => https://paste.pics/80f4230bf68.....b6415ece08
Value of Sheet 1 => F5 => '50' => is referenced in Sheet 2 => E4 => '50'
When i enter Value in Sheet 1 in place of F5 => Value gets Change in Sheet 2 => E4 => Automatically
Now the issue is
I want to print the DATA 1 and DATA 2 of Sheet 2 => That many times => how much value which is shown in place of Sheet 2 => E4 [Position] => in place of COLUMN => 'I' and 'J'
Like this Below Output :
My code which partially which print only one Column output but need to PRINT 'RAM' and 'RAJ' => COLUMN => 'I' and 'J'
Dim ws As Worksheet
Dim rDest As Range
Dim lCount As Long
Dim sValue As String
Set ws = ThisWorkbook.Sheets("Sheet2")
Set rDest = ws.Range("I2")
With ws.Range(rDest, ws.Cells(ws.Rows.Count, rDest.Column).End(xlUp))
If .Row >= rDest.Row Then .ClearContents
lCount = Val(ws.Range("E4").Value)
sValue = ws.Range("E8").Value
If lCount > 0 Then rDest.Resize(lCount) = sValue
Code for Sheet 1 : to enable call => of macros => mac
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Sheets("Sheet1").Range("F5"), Target) Is Nothing Then