I'm not searching for VBA solution but Excel formula one or any trick which might be helfpul.
Problem is following:
Sheet Main has in cell A1 reference number 1TF1234 and in cell A2 1TF5678.
Sheet Parties is empty and I want to create formula to populate cells A1 to A5 with value from cell A1 Main sheet and then A6 to A10 with value from cell A2 Main sheet and so on.
Main
A1 - 1TF1234
A2 - 1TF5678
Parties
A1 - 1TF1234
A2 - 1TF1234
A3 - 1TF1234
A4 - 1TF1234
A5 - 1TF1234
A6 - 1TF5678
A7 - 1TF5678
A8 - 1TF5678
A9 - 1TF5678
A10 - 1TF5678
Thank you for your help.
Aucun commentaire:
Enregistrer un commentaire