Tab Content
  • zeddy's Avatar
    2016-07-28, 11:26
    Hi RG ..here's my interpretation: The vba routine assigned to the button checks the data column This can be run after data is imported etc...
    15 replies | 233 view(s)
  • zeddy's Avatar
    2016-07-28, 10:18
    zeddy replied to a thread vlookup on merged cells in Spreadsheets
    Hi AJ ..that's exactly what I mean. If the workbook name, containing the client sheet, stays the same workbook name on the shared folder, that...
    7 replies | 82 view(s)
  • zeddy's Avatar
    2016-07-28, 09:43
    zeddy replied to a thread vlookup on merged cells in Spreadsheets
    Hi AJ So, you could have your own workbook, then import the data from the workbook with the client sheet and Table 1. Your workbook could then...
    7 replies | 82 view(s)
  • zeddy's Avatar
    2016-07-28, 09:23
    It is a truth universally acknowledged, that a man in possession of a wealth of Excel knowledge must be in want of a new Function or Event. ..the...
    15 replies | 233 view(s)
  • zeddy's Avatar
    2016-07-28, 09:07
    zeddy replied to a thread vlookup on merged cells in Spreadsheets
    Hi AJ My solution didn't unmerge or change the data. ..but it did add 'helper columns' and formulas. These helper columns could be placed far to...
    7 replies | 82 view(s)
  • zeddy's Avatar
    2016-07-28, 08:52
    zeddy replied to a thread vlookup on merged cells in Spreadsheets
    Hi AJ see attached file. This uses 'helper columns'. I've used index-match rather than vlookup for the formula. I note that you have used...
    7 replies | 82 view(s)
No More Results
About zeddy

Basic Information

About zeddy
Location:
Newcazzle, UK

Statistics


Total Posts
Total Posts
2,673
Posts Per Day
0.51
Total Thanks
Total Thanks
131
  • Thanked 443 Times in 421 Posts
General Information
Last Activity
2016-07-28 11:26
Join Date
2002-03-18
Referrals
3