Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Looking who can create the following file

Customer Question
Hello, Looking for someone who can...
Hello,
Looking for someone who can create the following file using Microsoft excel VBA or similar structure...
The backdrop to this project is we are an air conditioning company that maintain all the properties for a certain company. Each property can have several building and each building several suites. Once we access the suite, we want to be able to look at the maintenance that has been done on that specific suite. Not only that but we need to have it divided into 4 quarters. So for each quarter we can see what maintenance we have performed for that specific suite as each suite has its own air conditioning system...
Here are the specifics:
SCREEN 1: PROPERTY
(25 clickable buttons with editable property names)
scalable to 50 if company purchases more properties
*click a selected property*
SCREEN 2: BUILDING
List of buildings that belong to that property
(15 total buttons to open up screen 3 for that building to list it's suites)
SCREEN 3: SUITE
List of suites that belong to a building
(25 total buttons)
SCREEN 4: QUARTER
4 Quarters
1st, 2nd, 3r, 4th quarter buttons
SCREEN 5:
(No buttons needed, editable text box to plug in current maintenance we have preformed on the selected suite for that quarter)
American Air, LLC.
Victoria Childress
Pictures available upon request
Submitted: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
5 photos added.
Screen 1.jpgScreen 1.jpgScreen 2.jpgScreen 2.jpgScreen 3.jpgScreen 3.jpgScreen 4.jpgScreen 4.jpgScreen 5.jpgScreen 5.jpg
Answered in 1 hour by:
5/5/2016
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,206
Experience: 20 years experience providing remote computer support
Verified
looking at your pictures I am not sure that populating buttons like that makes much sense. have you considered the following, condintional drop downs. dropdown 1, select Property, drop down 2 will populate with buildings associated with selected propertydropdown 2, select building, drop down 3 populate wit suites associated with buildingdropdown 3, select suite, drop down 4 populate with quarter associated with suitedropdown 4, select quarter, text box created associated with selected quarter. Anyway something to think about. I have an appointment to go to now, but should be back later to discuss this further with you. You can let me know if this is something that sounds good to you,
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Im ok with that. I just want it to look appealing to the customer logging in on our computer. They will have access to this and will check frequently
Customer reply replied 2 years ago
Can you do it for us? I'm not familiar with the dropdown function
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
ok, i can do this for you but I will need you to create a sheet in the folowing format
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Okay are you wanting me to input the accurate names? I'm confused... this needs to be editable on my end so that if they add or remove a property I can do so as well.. I can go in and make the name once the dropdowns are completed correct?
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
so basically you will create a list in 4 columns, repeating anything that needs repeating so that you have one possible combination for each property, building, suite, and quarter. i mean how is everything linked to everything now
Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
So each property has a different name and buildings are numbered as well as suites. We don't have an exact number on each which is why we put in the photos (15 buildings per property) (25 suites per building) that way if a link goes unused it is better than not having one at all... make since?
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
yes, but even with buttons, you would still have to have each property associated with each building and each building with each suite, ect.. The reason I suggested drop downs is it is a little bit more dynamic as the list can be populated based on what the user selects regardless of how many buildings it has. The data would need to be arranged like the example though.
Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

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 CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

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!!!!

AlexLos Angeles, CA

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.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

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.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,206 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
Do you do excel formulas? excel 2007, pc yes all updated, no
Do you do excel formulas ? JA: What's the make and model of your computer? And what version of Excel are you using? Customer: excel 2007 JA: Have you installed any updates recently? Customer: pc yes a… read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,206 satisfied customers
We are a company wanting the best way possible to be able to
Hi, we are a company wanting the best way possible to be able to update our main Excel spread sheet which is imported to our software program (Axiapac). The Excel spread sheet contains product and pri… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have table 2 (its 835 lines) and I want to turn it into
Hi I have table 2 (its 835 lines) and I want to turn it into table 1 (they have all the same information) but cannot figure out how to do it as each competitor is repeated a number of times with data … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
Ok need a formula I Have Cell A C D O Cell o ----If Cell
Ok need a formula I Have Cell A B C D O Cell o ----If Cell A= 40 AND THE SUM OF (Cell B+(Cell C/2)+Cell D=<14) THEN 25 would appear IN Cell O IF Cell A= 40 AND THE SUM OF ( Cell B+( Cell C/2)+Cell … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
Need correct formula: Date1 Date2 3/15/15 7/1/15 1/14/10
Need correct formula for following: Date1 Date2 3/15/15 7/1/15 1/14/10 1/1/14 If Date2 field is-blank then target cell formula >=datevalue("6/1/15"),"PY15","PY14", and if Date2 and Date1 fields hav… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I am trying to create a drop down list that allows multiple
I am trying to create a drop down list that allows multiple selections and then places those selections, comma-delimited, into a cell. I need each row in the column to be able to access the list and a… read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,206 satisfied customers
excel - I am building a little automated spreadsheet and I
excel - I am building a little automated spreadsheet and I would like to insert a button which, when activated, would initiate a macro that would get data and formatting from a named range and insert … read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,206 satisfied customers
I have a spreadsheet that has several "pages" all in sheet
I have a spreadsheet that has several "pages" all in sheet 1. When I add a footer to number the pages, they all have the same page number. I need to customize these page numbers since the sheets will … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I want to look at a group of 2,3 or 4 digit numbers and count
I want to look at a group of 2,3 or 4 digit numbers and count how many times each digit shows up.… read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,206 satisfied customers
Hi Richard, Tried to protect everything on my worksheets
Hi Richard, Tried to protect everything on my worksheets but the couple of ranges that people should be able to enter data into. Pretty straightforward except that one of the ranges I'm selecting cont… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
I need help creating a spreadsheet that tracks our vacation,
I need help creating a spreadsheet that tracks our vacation, holiday and paid time off based on hire date Vacation - Each employee is entitled to 5 days in year one of employment and then from year 2-… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a very difficult formula to build… Do you think Excel
I have a very difficult formula to build… Do you think Excel 2010 (I bought last month), can do that? If yes, would it take 30 lines of codes? If not, what software do I need? (i) 100% of the calculat… read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,206 satisfied customers
Could you please assist in a formula to calculate hours in
Could you please assist in a formula to calculate hours in a day and breaking down to an individual activity? For example in one column I will have the activity e.g. auditing, safety walks etc. In ano… read more
Kamil Anwar
Kamil Anwar
Office Specialist
Bachelor's Degree
219 satisfied customers
Is it possible to add a notification box to a form that on
Is it possible to add a notification box to a form that on a specific date will send an E-mail to an individual? I have a sample database if you need it. Thanks John… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
Do you still have the IT163 final project? I need unit 8 and
Do you still have the IT163 final project? I need unit 8 and 9 if you can help that would be awesome I can send you the information on them.… read more
Steve Herrod
Steve Herrod
Senior Customer Care Engineer
Master\u0027s Degree
882 satisfied customers
I need a formula that will conditional format unsorted data
I need a formula that will conditional format unsorted data in 9 rows and show which of the data points are within some value (specified in a header cell...usually 0.5 to 1.5) of any of the other valu… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello,I am very new to Excel and cannot get my head around
Hello, I am very new to Excel and cannot get my head around macros. It doesn't help that I am also blonde! I am using MS Excel 2003. I understand that my approach is probably not the most efficient, b… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I would like to know how many records you can have in a Access
I would like to know how many records you can have in a Access Database, and if you can setup a query to run a list of specific numbers for multiple combinations of a 4 number code. Kenny… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x