Hello all I am using Excel 2007, have the need to validate a large amount of data in one workbook which looks up data from a separate worksheet. My main problem is the size of the sheet, number of columns goes from A to OY in one instance, number of rows is easier only 500. I have added an empty column next to each column of data in my main spreadsheet, into these columns I want to add my Vlookup formula, however each formula needs to be edited to bring in the appropriate data based on the Col_index_num, which has to be incremented by 1 when added to each alternate column. You can see that this is no easy task manually, Once the formulas have been updated they need to be copied down into each row in each alternate column.Can anyone please provide me with a macro or script to undertake this task.
I have attempted to use record macro, but am getting lost in doing the editing to get the correct code and sequence for the loop till end bits. Any help will be greatly appreciated Regards Brian -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel