Apr 28 2018
01:32 PM
- last edited on
Jul 25 2018
11:51 AM
by
TechCommunityAP
Apr 28 2018
01:32 PM
- last edited on
Jul 25 2018
11:51 AM
by
TechCommunityAP
Hi, hoping you can help me, I have created a spread sheet in sheet 1 for names and info for entry to a judo competition and in sheet 2 I have created a weigh in card, what I need to do is get the relevant information to auto add to the weigh in cards, I've created formulas for card 1 off entry 1 but can't get it to do card 2 with out individually putting all the formulas in again. We are accepting 75 entries so if I have to do them all individually it will take me forever, is there a way to do it quicker. The weigh in cards are 2 wide by about 4 down per page.
Not sure if I've made sense sorry?
Apr 28 2018 03:14 PM
SolutionEmma,
I replaced the direct references in the first card with INDEX() formulas and used a helper column for the row numbers.
Then I copied the first card to the right which needed a second helper column for the next row numbers.
Then I copied the first two cards down till the end.
Apr 30 2018 01:37 PM
that is perfect thank you, done really understand what you've done but can see the code to copy etc to do the rest.
You have save me alot of time thank you again
Apr 28 2018 03:14 PM
SolutionEmma,
I replaced the direct references in the first card with INDEX() formulas and used a helper column for the row numbers.
Then I copied the first card to the right which needed a second helper column for the next row numbers.
Then I copied the first two cards down till the end.