Excel Formula

By Lynnette.Napolitano ·
What formula would work if I wanted to copy detailed from spreadsheets in a book identified by date and automatically copy the detail from specific cells on each dated spreadsheet into one column in a master spreadsheet?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Depending on how your data is laid out........

by ThumbsUp2 In reply to Excel Formula

Either vLookup or hLookup should do the trick. But, you might need to add and IF or two.

If you give us more detail, we might be able to help more.

Related Discussions

Related Forums