Help filling in Excel form

Madwitch

macrumors member
Original poster
Feb 4, 2013
31
2
North Yorkshire, UK
I have a certificate on excel which covers 25 columns and 69 lines. I need to insert information into about 10 of the cells (the rest of the information is the same). Unfortunately the spreadsheet is too big to transfer to Word, otherwise I'd use Mail Merge. Is there a way of doing this without having to insert the information into each form? I have about 2000 to do on this round (they are electrical test inspection certificates, and there will be another 5000 or so shortly!) and any way of making this a bit quicker would be welcome.
 

Samuelsan2001

macrumors 604
Oct 24, 2013
7,694
2,123
You can probably write a macro that will do it but you'll have to do a fair bit of research to learn how to write one. If you are lucky there will be something online that does what you want.
 

Madwitch

macrumors member
Original poster
Feb 4, 2013
31
2
North Yorkshire, UK
Ah thanks. Steep learning curve coming up! I'm not sure of the technicals but I gather Word has a behind the scenes command which tells it to put each record on a new page - and this bit is missing in Excel.
 

Mousse

macrumors 68020
Apr 7, 2008
2,189
3,893
Flea Bottom, King's Landing
I like to keep things simple with VLOOKUP and HLOOKUP. The biggest drawback is your data has to be a specific format. I have a spreadsheet where I have to enter customer information (12 different cells). With VLOOKUP, HLOOKUP, I enter the customer's name, everything gets filled out automatically. For thousands of entries, I would add another column numbered from 1 to 1000 (or whatever) as the look up reference.

As long as the raw data is consistent (names, address, phone #, grade, date all in their own columns) then this would work. The look up data on one sheet, the actual spreadsheet on another.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.