Hi All, I'm a bit new to the whole world of coding behind Excel, but I have created a little program that will generate some reports at work. Its working great on my laptop, but when others run it, it goes through the motions with no error messages, but none of the figures update.
The overall process of the system - Users paste in data to a tab, the next tabs grab that data with a few filters on it and paste it into another tab. That pasted data drives the reports.
For some reason, when others run it on their computers, it isn't pasting the data, so while it appears the reports are "updated", they aren't.
I've gone through several options, looking at references which are being used, and they are all working fine on all the machines that have been tested, none say missing or anything.
The whole code is built in a set of modules, which are simply called in order - In my head the code is very basic, and I can't see where the issue falls.
Below is a look at the first step of code I use - This is the bit that seems to not be working. Its aim is simply to grab data from one tab (build tracker) in this Excel document, and paste it into another tab (Base Data), and add a few formulas.
Any help would be massive! Or ideas of other areas I could check
Please Login or Register to view this content.
Bookmarks