I am having issues copying one of the worksheets and pasting them all to the others. It is my understanding that they all the should update and select the proper worksheet such as I copied the data from tab 1 and pasted it on tabs 2-31. Shouldn't it update to the corresponding table? I must be doing something wrong, I don't want to go one by one and update the information help would be greatly appreciated. Sheet is below
I am not able to understand your question. Please try explaining it with some more detail. Where are you not seeing any updates happening?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
On tab 8 the code shows below, but when I copy and paste it to the all the other tabs it still comes up with the same code.
='G:\CPR\Original\[Martinez.xls]8'!C2 + 'G:\CPR\Original\[Morales.xls]8'!C2 + 'G:\CPR\Original\[Ross.xls]8'!C2 + 'G:\CPR\Original\[Pascual.xls]8'!C2
Tab 9 is suppose to have the code
='G:\CPR\Original\[Martinez.xls]9'!C2 + 'G:\CPR\Original\[Morales.xls]9'!C2 + 'G:\CPR\Original\[Ross.xls]9'!C2 + 'G:\CPR\Original\[Pascual.xls]9'!C2
notice how the 8 is replaced with a 9. My issue is the tabs are suppose to update to the corresponding tabs. Thats why. Do you understand.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks