Hi,
We are using iPads to gather data in the field, which is e-mailed to me, where a VBA macro chunks through my inbox and takes all relevant Excel-files there.
I have made a Numbers Template, to make sure all relevant data is filled in the correct fields, but sometimes (not always!) when exporting from Numbers to Excel, it adds an extra row and column!
so what is A1 on my iPad is B2 when opened in Excel...
I have attached two pictures, this is the same file on my iPad and in Excel on my PC.
all data is blurred out, and a dummy function is written in A1 to illustrate the problem. in Numbers it is correctly in A1 = A2+A3+A4 but in Excel its B2 = B3+B4+B5...
I hope someone can help me, since I cannot find whats causing this!
Bookmarks