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 The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1844
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I'm trying to setup a master spreadsheet with all project data

Customer Question

I'm trying to setup a master spreadsheet with all project data in it. Then I want individual project data per sales rep to show up on their own respective spreadsheets that will be protected.
Submitted: 1 year ago.
Category: Programming
Expert:  The-PC-Guy replied 1 year ago.
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question
it should be possible
can you send an example file?
Customer: replied 1 year ago.
Yes what email address? I will send it in about an hour..
Expert:  The-PC-Guy replied 1 year ago.
you can attach the file here.
use a site like
ge.tt
after uploading the file they give you a link
paste that link here
Customer: replied 1 year ago.
http://ge.tt/1nuPuiG2/v/0Here is the worksheet we are working with.
Expert:  The-PC-Guy replied 1 year ago.
i will take a look at it and get back to you
Customer: replied 1 year ago.
have you had a chance to look at this yet?
Expert:  The-PC-Guy replied 1 year ago.
yes,
so you want to take each name out of the list, and create a separate sheet for each name with their info?
Customer: replied 1 year ago.
We would like to have a master sheet, and within there create another sheet with the individual sales people's information pulled to another sheet. So the master would have all sales transactions, but then each sales person would have their own sheet with just their transactions pulled onto. And as the master is changed we would like the individual sales reports to update too.
Expert:  The-PC-Guy replied 1 year ago.
so there is going to be an addtional sheet to the master sheet that will create another master sheet + additional sheets?
Customer: replied 1 year ago.
One master sheet with other sheets pulling from the original master sheet.
Expert:  The-PC-Guy replied 1 year ago.
right i think i get it so for example
say master sheet has
Anna
Charly
Bob
you would have 3 separate sheets for each of them.
Does preserving the formatting matter?
you can two options. Preserve formatting, will run a little slower. Or just copy data, will run faster.
So if you have a lot of rows on master sheet I would suggest just doing data.
Customer: replied 1 year ago.
Are you able to create this spreadsheet with formats for us?
Expert:  The-PC-Guy replied 1 year ago.
sure, like i said it can be done either way.
I am sending you an additional service offer now, because this is quite involved.