Season's greetings to all
I have a workbook with 12 identical worksheets, where on each worksheet there are around 1,200 cells that could have required the use of INDIRECT, but the data needs to be pulled from closed workbooks so, I have considered the UDF "Pull" from this thread http://www.mrexcel.com/forum/showpost.php?p=2131711&postcount=5
Now can you guys advise me if this advisable, because while I was testing, I tried it on one cell and there was a delay of like 1/2 sec when updating that one cell, so can you tell me if it would be a bad idea to use on all 12 identical worksheets that basically will all update at the same time depending on month selection to be done from a drop down list on B3 on any of the worksheets?
On a similar note, a member from another thread has provided me with this code so that ll worksheets update to the selection done on B3 on any worksheet:
I have requested help on this thread http://www.excelforum.com/excel-pro...ll-worksheets-simultaneously.html#post2209416
About the issue that given that I have that UDF it not working too well. If I remove the "pull" formula from all cells which I used to test. Then that code works. Any ideas on this? I can't even inset any line in the immediate window because of that UDF, I believe...
Thank you guys!!!
I have a workbook with 12 identical worksheets, where on each worksheet there are around 1,200 cells that could have required the use of INDIRECT, but the data needs to be pulled from closed workbooks so, I have considered the UDF "Pull" from this thread http://www.mrexcel.com/forum/showpost.php?p=2131711&postcount=5
Now can you guys advise me if this advisable, because while I was testing, I tried it on one cell and there was a delay of like 1/2 sec when updating that one cell, so can you tell me if it would be a bad idea to use on all 12 identical worksheets that basically will all update at the same time depending on month selection to be done from a drop down list on B3 on any of the worksheets?
On a similar note, a member from another thread has provided me with this code so that ll worksheets update to the selection done on B3 on any worksheet:
Code:
[FONT=Arial][SIZE=2][COLOR=#000000]
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim ws As Worksheet
On Error GoTo ExitPoint
If Intersect(Target, Range("B3")) Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> Sh.Name Then ws.Range("B3").Value = Target.Value
Next ws
ExitPoint:
Application.EnableEvents = True
End Sub</pre>[/COLOR][/SIZE][/FONT]
I have requested help on this thread http://www.excelforum.com/excel-pro...ll-worksheets-simultaneously.html#post2209416
About the issue that given that I have that UDF it not working too well. If I remove the "pull" formula from all cells which I used to test. Then that code works. Any ideas on this? I can't even inset any line in the immediate window because of that UDF, I believe...
Thank you guys!!!