Word for mac cant insert columns11/8/2023 ![]() Hi I have total 6+ years of experience in excel reporting and VBA macro I can complete your work in a short time. sheets excel file finding column hedear, create sheets excel column data vba, excel data merge, pdf excel mail merge, vba code update sheets excel. The problem is, I want excel to find the number shown in B1, which could be in any column on row one of another sheet and then finding the result for the next lookup criteria, which could be in one of two places….if found in the first group and result is blank, look in the next group to find the data. ![]() There may well be better ways of achieving the. If the original data was text or values the formulae in ColumnD can then be replaced with Copy/Paste Special/Values. [If the data has adjacent repetition a 'helper' column can be used (say ColumnD here, since the helper column is only temporarily required).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |