Worksheet change event required for linking sheets

[Jyotirmaya]

Worksheet change event code required for linking between 2 sheets one is Raw Data other one is SH


I want that if there will be any value in AH column of Raw data sheet then B Column value of Raw data sheet will be linked to C column of SH sheet staring from Row 4 onward in SH sheet.

 

[sunny102]

use this code

for i=4 to 100
if Sheets("Raw Data").Range("AH" & i)<>"" then
Sheets("SH").Range("C" & i)=Sheets("Raw Data").Range("B" & i)
end if
next

 

[Jyotirmaya]

use this code


for i=4 to 100
if Sheets("Raw Data").Range("AH" & i)<>"" then
Sheets("SH").Range("C" & i)=Sheets("Raw Data").Range("B" & i)
end if
next

can you please complete the VBA code from the begining ? I am not aware of VB much.

 

[sunny102]

Sub test
for i=4 to 100
if Sheets("Raw Data").Range("AH" & i)<>"" then
Sheets("SH").Range("C" & i)=Sheets("Raw Data").Range("B" & i)
end if
next
End sub

 

[Jyotirmaya]

Sub test
for i=4 to 100
if Sheets("Raw Data").Range("AH" & i)<>"" then
Sheets("SH").Range("C" & i)=Sheets("Raw Data").Range("B" & i)
end if
next
End sub

It works thanks..


Little more help I want. I want some addition of code in the existing code.


for example the AH4 have some value then as per the code Raw data B4 = SH C4


For example, again in AH8 there is value so in that case I want sum of Raw data M5 M6 M7 M8 in the next row of SH in D column.

 

[sunny102]

what is sequence for filling the value in column D, I mean what should be the value in SH- D4 if there is data in Raw Data- AH4 or the logic for this neds to start from row 8 only?

 

[Jyotirmaya]

As you can see the pic where there is single entry I can get copied the values from Raw Data sheet to SH sheet with your code but where there are multiple entries I need the sum of Total column of M S & Y in the SH sheet.

I have headers in SH sheet so the values can be started copying from Row4 of SH sheet onwards

SH sheet demo.. I want like this