We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Experts ?
statman
Posts: 167 Forumite
in Techie Stuff
Does anybody know if there is a way of merging several spreadsheets into one whereby the information drops into the correct headings(if they are there)?
Not a big deal but the number of times I find myself cutting and pasting info!
Thanks
Not a big deal but the number of times I find myself cutting and pasting info!
Thanks
0
Comments
-
Not 100% sure what you are aiming at, but have a look at help on VLOOKUP, MATCH, INDEX and INDIRECT functions may give you some ideas. All can use linking to other Books/Sheets to pull info from other spreadsheets together.0
-
Thank you both I will have a look through, it gives me some hope of a solution.
Thanks0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.4K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.4K Spending & Discounts
- 245.5K Work, Benefits & Business
- 601.3K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards