Not sure if I can do it... automated data transfer from specific cells to a new workbook

Flashy

New Member
Joined
Oct 20, 2013
Messages
2
Hi, I use excel to run a ton of formulas and such to run a custom table-top rpg system. Up until now I've usually been able to just Google things I need to know, but I'm trying to add in a function that I'm having difficulty finding information on, assuming it exists at all.

What I have are basically player sheets. They have lots of formulas on them that calculate just about everything that needs to be calculated in the game, but as I keep changing and updating the system, I keep having to change the player sheets and the formulas contained within them, as well as updating other tabs. Players often control multiple characters, and so have several instances of these player sheets. The issue right now is that it's a bit of a bother to update all of the player-entered data, because the method we are using is just manually transferring that information from the old file to the new file, which amounts to about 300-400 cells of data (most of which is in columns, and very easy to copy and paste), but I would really like a faster way to do this.

So, what I'm looking for is a way to automatically update either all of the game system formulas and what-not from an updated excel file to the players' already existing (and now out-dated) files, or the opposite, updating all player-entered data from the old file into the updated file, and skip the step of manually copying and pasting the information. I do not want to use multiple workbooks. We used to do this, but there was simply too much data to look-up, and it caused a huge lag issue; if that's what I'd have to do, it'd be easier just to continue manual entry.

I'm using excel 2007. At my current rate of updating my game, I'm having to get players a new version of the excel file every week, and once even dished out 2 updates inside of a one-week period, and most of my players don't even know how to use keyboard shortcuts so you can see why I'm trying to get this done. We could cut down on like... a half an hour of waiting for everyone to update to the new version during our 3-4 hours sessions every week.

Thanks for any help you can offer!
 
Can you provide more information about the data you are trying to update? What sheet are they on and in which columns? Where are they referenced in the formulas, and what are the formulas currently being used?

Can you post some screenshots or sample data?
 
Upvote 0
Can you provide more information about the data you are trying to update? What sheet are they on and in which columns? Where are they referenced in the formulas, and what are the formulas currently being used?

Can you post some screenshots or sample data?

Untitled.png


It's based on pokemon (as you can see). All of the tan cells are the ones where players input data. The four large sections go down some 100 or so rows. There is no real limit on how many pokemon the players can each have, and each new one will require another tab like this. As to where is the data used... everywhere... and data is being pulled in from each of the squared tabs as well. Using lots of LOOKUP formulas, there's mathematical formulas in almost every cell that has a formula (anywhere you see a number, basically). Some of those cells are also drop-down menus. There's also about 5 columns to the right, off-screen where some more calculation and lookup stuff is going on since the formulas were getting too long to look at on their own. All of the player-entered data is in raw number/text format, no formulas.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top