Hi all,
Sorry if something like this has been covered before, but I couldn't find the exact answer I am looking for.
see attached...
So I am looking to insert a formula in FollowUp! that will copy and paste the data in range N-S in Calls!. So if I enter "r" in column M in Calls!, I want the information automatically populate the same cells in FollowUp!.
In other words, putting "r" in M2 in Calls! will paste the data in N2:S2 in Calls! into N2:S2 in FollowUp! The catch is that I do not want blanks, so if the next "r" isnt entered in Calls! until M6, I want that data pasted into N3:S3 in FollowUp!
Clear as mud?? Would love to attach an example workbook...but I guess I'm not allowed...
Been tinkering with IF and VLOOKUP and just can't seem to find the right function...time to ask the experts!
Hopefully my objective is clear...and someone has a simple answer!
Thanks!
Mike
Sorry if something like this has been covered before, but I couldn't find the exact answer I am looking for.
see attached...
So I am looking to insert a formula in FollowUp! that will copy and paste the data in range N-S in Calls!. So if I enter "r" in column M in Calls!, I want the information automatically populate the same cells in FollowUp!.
In other words, putting "r" in M2 in Calls! will paste the data in N2:S2 in Calls! into N2:S2 in FollowUp! The catch is that I do not want blanks, so if the next "r" isnt entered in Calls! until M6, I want that data pasted into N3:S3 in FollowUp!
Clear as mud?? Would love to attach an example workbook...but I guess I'm not allowed...
Been tinkering with IF and VLOOKUP and just can't seem to find the right function...time to ask the experts!
Hopefully my objective is clear...and someone has a simple answer!
Thanks!
Mike
