Forum Discussion
Solved
Transferring information from a spreadsheet on 1 sheet to a card on another
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 rel...
Emma,
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.
Emma,
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.
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
