How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete
Pete, Computer Enthusiast
Category: Microsoft
Satisfied Customers: 17292
Experience:  Over 16 years of experience in the Electronics and IT industries.
30970729
Type Your Microsoft Question Here...
Pete is online now

Hello I have a complicated thing to do. I have over 100 worksheets

Customer Question

Hello I have a complicated thing to do. I have over 100 worksheets which represents each property we rent out for holiday rentals. I want these bookings on the separate sheets (a line per booking) so I can see each line of holiday booking but I also want to see all holiday bookings from each property on one sheet with the dates of payments so I can search for who owes money and when (on one sheet rather than checking each of the 100 sheets each week) can anyone help?
Submitted: 3 years ago.
Category: Microsoft
Expert:  Pete replied 3 years ago.
Hi there,
I am Pete, and I'll be happy to assist with your question.

You can put all the information onto one master worksheet by "consolidating" the data.
For full instructions on how to do this, see:
http://office.microsoft.com/en-gb/excel-help/consolidate-data-from-multiple-worksheets-in-a-single-worksheet-HP010342300.aspx

If you have any difficulties, just let me know, and I can either answer you here, or assist remotely via screen sharing.

Remember, you can still ask free followup questions at any time, even after rating my service :)

Best regards,

Pete.
Customer: replied 3 years ago.

Hello Pete


 


I was expecting someone to take me through this? As the help files are a bit too difficult for me. Is this something you could do with me? I could send you a dummy file so you could see it?


 


Thanks


 


Jenny

Related Microsoft Questions