Hi I have below criteria for move from sheet 3 to specific cells in sheet 2 and sheet 3.
Its a list of words and i want the word coming after to be copied and moved.
Example i have fullName: to B5 Sheet 2 . It had to search after fullName: an copy the word after the : to B5
fullName: Bo olsen example it have to copy Bo Olsen to B5 in sheet 2.
Where the words can be is variant thats why i need to search for it.
Below are the words i need to search for and copy after the :
Please have a look and see. I also put a test sheet which can be good to play with and also understand it.
Thanks in advance
Sincerely
Abjac
these are the creterias:
All data is in row 1 and 2 sheet 3
And it goes from column A to DD
All after the : have to be copied.
fullName: to B5 Sheet 2
contactPhone: to B9 Sheet 2
callMeetingDate: to B11 Sheet 2
contactEmail: to B8 sheet 2
jobFunction:to B6 sheet 2
CTRY:DK to B13 sheet 2
accountPhone:to B20 sheet 2
accountName:to B12 sheet 2
accountEmail: to B16 sheet 2
accountVatNumber:to B21 sheet 2
accountRangeEmployees:to B18 sheet 2
accountRangeRevenue:to B17 sheet 2
accountIndustry:to B24 sheet 2
accountSubIndustry:to B25 sheet 2
accountWebSite:to A6 sheet 3
BillingStreet:to A5 sheet 3
BillingCity:to B5 Sheet 3
BillingPostalCode:to C5 sheet 3
accountWebSite:to A6 sheet 3
Next is special want to merge the cell after interactionNote: with the next 5 cells in same row
interactionNote:\ Merge this cell and the next 5 cells in same row to first cell and copy all to A7 in sheet 3
Bookmarks