the instructions of your spreadsheet say that the light blue fields have excel equations that would bring in data. if i however click on the fields there is no equation show. if i enter data in the white fields nothing happens.
also, the columns B & C for name and username are marked as light blue (so according to the instructions i shouldn't edit them) but don't i need to enter this data?
Apologies for the delay in responding. I wasn't subscribed to this thread.
The blue columns do contain equations. I just haven't copied the equations to the rest of the rows because I don't know how many users you have. If you click on cell B4 or C4, for example, you'll see the equations. Just AutoFill these for subsequent rows.
The userfields in columns B and C get their data from columns further to the right. To enter the user's first name, for example, go to column Y.