Follow via:
RSS
Email Alert
Question
0 Votes
+ -

Excel Formula

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?
15th Apr 2009

Answers (1)

0 Votes
+ -
Depending on how your data is laid out........
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.
15th Apr 2009
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.