by samhayer » Tue Jun 11, 2024 12:43 pm
Hi everyone I hope all are well, I need some help with this sheet I have been working on, I am no expert with VBA and Macros just trying learn as I go long. I would like to thank all and every one who read this and are able to help me in any way . So I have been working on a Sheet which is now working to some extent but has still got a few thing to sort out before the job is good . I will try and address one problem at a time and hope to fix these and have a working sheet and learn some VBA . Ok so In my market sheet (Sheet1) I have put this VBA code in the Worksheet. j
Private Sub Worksheet_Calculate()
If Sheet1.Cells(5, 37) = 1 Then
CopyAI5
End If
End Sub
so what this does is if Row 5 and Colum 37 is equal to 1 a macro called CopyAI5 willcopy and past the value from AI5 toAG5 this is all working fine
Now I want to add to this worksheet If Row 6 and Colum 37 is equal to1 then a Macro called CopyAI6 will Run.And 1 would like continue to add another 13 Makros up to
If Sheet.Cell(20, 37)=1 Then CopyAI20
I have tried putting different codes in but none work. Please can some one advise me on this or if a developer can help I have a few other things need to be looked at also thankyou all. Best Regards. Sam Hayer