Automatically print a single row (active row?) in table format using a button

cjackson448 · May 3rd 2020

Hello, I am creating a spreadsheet and have some tall orders. The one I'm stuck on is how to print the data on the active row in a memo style or even a table format.b It would be to hand out to the associate assigned to. I also need the row to turn red when a dropdown (not dispatched) is selected. I have attached the spreadsheet for reference.

Thank you! REVISIONS 4.24.20ML SPD Weekly Dispatch Call Log_TEMPLATE_4-22-20.xlsx

**royUK** · May 4th 2020

The highlighting can be easily achieved using Conditional Formatting

You can create a "memo" style sheet in another sheet and populate with VLOOKUP. You need to add a column for a reference number, then use the reference number in the VLOOKUP

Automatically print a single row (active row?) in table format using a button

Participate now!

Share

Tags