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: 31253
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: 3 months ago.
Category: Microsoft Office
Expert:  Russell H. replied 3 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 3 months ago.
yep
Customer: replied 3 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 3 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 3 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 3 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 3 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 3 months ago.
Is that $39 too? Awfully expensive
Expert:  The-PC-Guy replied 3 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 3 months ago.
No thanks
Expert:  Richard replied 3 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?