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 Richard Your Own Question
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36526
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I am trying to make a summary sheet in excel from multiple

Customer Question

I am trying to make a summary sheet in excel from multiple worksheets. I don't need any data sum, I just need a list of the same cells from each sheet.
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Russell H. replied 10 months ago.

Hi, thank you for contacting JustAnswer.com. My name is Russell. I will do my best to provide the right answer to your question.

Do you mean, that you want a single sheet (in Excel) to acquire data from other sheets, but just present each cell as it is in the source sheet, without adding/formulae/etc. ?

Customer: replied 10 months ago.
yep
Customer: replied 10 months ago.
I attached the spreadsheet and the tab listed as all products is what I am trying to make a list containing only minimal cells from each sheet
Expert:  Russell H. replied 10 months ago.

OK, cells from each sheet.

How soon do you need this? I can maybe get it done by tonight (EDT zone), since I have lots to do.

Customer: replied 10 months ago.
I can do it by clicking cells in each sheet. I thought there would be a quick way to populate it. Not interested in waiting.
Expert:  Russell H. replied 10 months ago.

OK, then, I have Opted Out, in favor of any Expert here who can provide what you need soon.

Expert:  The-PC-Guy replied 10 months ago.

this can only be achieved with a macro.

There will be an additional fee to create a macro

Is this something you are willing to consider

Customer: replied 10 months ago.
Is that $39 too? Awfully expensive
Expert:  The-PC-Guy replied 10 months ago.

i know, but there is a bit of work involved to make it work, and it is actually quite inexpensive.

The only other way is to manually add formulas for each sheet and manually change the sheet name each time.

SO it depends of if it is worth it to you.

Customer: replied 10 months ago.
No thanks
Expert:  Richard replied 10 months ago.

Hi there Thomas and welcome

Can you connect the camcorder to a different USB port on the computer and tell me if it is then detected in the software please?

Related Microsoft Office Questions