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 Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Software
Satisfied Customers: 160
Experience:  Familiar with a wide variety of software and experienced in user training/support
65126503
Type Your Software Question Here...
Steve Herrod is online now

We have an excel sheet that we require a macro facility to

Customer Question

Hi
We have an excel sheet that we require a macro facility to help us organise data. We are looking at streamling the office tasks by department, pay level of the task on a grading of 1-7, by occupation of the staff member, by time they are in the office. We have this data in an excel sheet and are looking for a macro to run that will create the result we are looking for rather than manually working through the list.
If you feel that this is something that you can do let me know and we can touch base on the detail a little more.
Thanks
Thanks
Rachel
Submitted: 13 days ago.
Category: Software
Expert:  The-PC-Guy replied 13 days ago.

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

Expert:  The-PC-Guy replied 13 days ago.

if you could send an example file, that contains some data and the output that you want it to look like, will see what can be done

Customer: replied 13 days ago.
Hi I have attached the file.
I have attached the SL task sheetThe sheet has x2 tabs master and SL, Department, WH.The master sheet includes a list of all tasks completed by staff at my offices.Sheet 2 includes a list for all staff, the total hours they are available each week, the department they work in and the task level that they should be dealing with in line with pay grade. All staff have 3 levels. Olu’s, Maria’s, Steve and Lisa A hours are split to 18.75 and listed twice, allowing for task allocations working on and in the business.I am trying to run a macro that looks at the data in both sheets and according to the tasks, level of task and department allocates appropriate tasks within the master sheet to staff in sheet 2 depending on the key criteria of department and level of task appropriate to their pay grade.We are still working on the last 2 columns of the master sheet to better qualify timescales and frequency. This work will be completed by tomorrow. In the meantime can you make an assessment as to if the task that I am requesting is even a possibility.Thanks
Rachel
Expert:  The-PC-Guy replied 13 days ago.

i am having a hard time wrapping my head around this. I would help to get a visual idea of what the output would look like or for a few examples what you want the results to look like. In other words do a few manually that show how everything is arranged

Customer: replied 13 days ago.
Will do, I will look at this now and email you back.
Sorry that I didn't reply sooner I left the office at 3.30 yesterday.

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Steve Herrod

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
< Previous | Next >
  • http://ww2.justanswer.co.uk/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
  • http://ww2.justanswer.co.uk/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    116
    Computer Software Support specialist for more that 10 years
  • http://ww2.justanswer.co.uk/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    114
    Certified Software expert with over 10 years experience.
  • http://ww2.justanswer.co.uk/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S's Avatar

    Frederick S

    Computer Specialist

    Satisfied Customers:

    91
    Computer technician; founder of a home PC repair company.
  • http://ww2.justanswer.co.uk/uploads/WA/wa94sound/2012-6-6_202633_iStock000007010121Small.64x64.jpg Bernie's Avatar

    Bernie

    Software Support

    Satisfied Customers:

    52
    6+ years experience, Microsoft MCDST/CompTia A+ Certified
  • http://ww2.justanswer.co.uk/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    38
    20 years experience providing remote computer support
  • http://ww2.justanswer.co.uk/uploads/jnayes/2010-12-23_132454_japicbetter.jpg jnayes's Avatar

    jnayes

    Computer Support

    Satisfied Customers:

    37
    Network Administrator
 
 
 

Related Software Questions