I am a novice user, took a sample Forms sheet from Contexture.com and modified it..
But when I added two Subs to copy data from one sheet to another it slowed down very much.
Code is following:
Sub NewEntryUpdateMaster()
'new entry issued update
Dim issuedlocation As Range
Dim balancelocation As Range
Set issuedlocation = Worksheets("Input").Range("I33")
Set balancelocation = Worksheets("Input").Range("I34")
Worksheets("MasterList").Range(issuedlocation).Value = Worksheets("Input").Range("D24").Value
'new entry balance update
Worksheets("MasterList").Range(balancelocation).Value = Worksheets("Input").Range("D27").Value
End Sub
I this code too taxing to cause slowdown?
Note: I am using Excel 2007
Can anyone help / guide?
But when I added two Subs to copy data from one sheet to another it slowed down very much.
Code is following:
Sub NewEntryUpdateMaster()
'new entry issued update
Dim issuedlocation As Range
Dim balancelocation As Range
Set issuedlocation = Worksheets("Input").Range("I33")
Set balancelocation = Worksheets("Input").Range("I34")
Worksheets("MasterList").Range(issuedlocation).Value = Worksheets("Input").Range("D24").Value
'new entry balance update
Worksheets("MasterList").Range(balancelocation).Value = Worksheets("Input").Range("D27").Value
End Sub
I this code too taxing to cause slowdown?
Note: I am using Excel 2007
Can anyone help / guide?