Quote:
Originally Posted by ArviLaanemets
And the tool does exactly this! You paste your orders info into Table in rightmost sheet, and you get the new tournament info (rows which doesn't exist in tournament table jet) in 2nd sheet from left. I added comments in red shrift into every page, where is explained, for what the page/table is for!
Contrary what you did write, I couldn't identiyfy from where to read some info to be put into tournament table from orders table. So this part of info is missing currently, and you have either to add missing formulas yourself (the calculation steps are ordered from right page to left), or you have to give better information, from which columns of orders table this info must be read.
|
So sorry I missed the different tabs; I am horrible with excel. In the fields, id, exp. State, rate, and local can all be blank. If the state is IL, that is also fine.
I tried it with data from one of our old tournaments. I cleared out everything. I pasted the order information into orders using paste. When I checked out data verification, I see the GR (grade) tab is blank I do need that information. On the team tab, I need it to only list the 5-letter abbreviation, ex WLKCH or MNRHN (not WLKCH: Walker School Clarendon Hills, IL or my program won't read it).
I can't begin to thank you enough. It means so much to me, and you will make hundreds of kids very happy each month.
11-18-2022, 02:06 PM
Similar Threads
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
Windows 10 
Office 2019
Threaded Mode