rjn529

I have a file that is many worksheets, where 1 data input sheet feeds the other worksheets. Data is input monthly. On a summary page, I need to be able to easily convert cells from a calculation to the actual value. I am calculating a percent returned based on number of surveys returned versus number of employees in the department. Since the number of employees varies greatly from month to month, I need to have the percent returned keep the value from the month and not recalculate based on the new number of employees for the current month. Since there are over 2700 employees in the company, manual conversion is not an option. Is there an easy way to do this? Thanks!

I recently bought a Samsung S4 - my first smart phone. I have a lot of contacts added, with birthdays set up as an 'event', which is where I found birthday. I want to add these contacts' birthdays to the calendar, but can't figure out how to do it. HELP!!!!! Thanks.

I have connected 2 tables in a query, and the results work fine. But I'm trying to put in a date criteria to pull only particular records. I have a third table, not part of this query, where a start date and end date is keyed in once for the period, and would like to only have to update these fields once for all queries for my billing. I've keyed in the criteria of

Between ([Tables]![Billing Period Dates]![Start Date]) and ([Tables]![Billing Period Dates]![End Date])

But when I try to run it, it just comes up asking for these dates as the parameter. I've also tried it without the word "tables" and without the parentheses. Same thing happens.

I'd like to be able to pull them from this table as the dates are used in multiple queries to run the billing and I don't want to have to key them in each time.

I have a customer database that I am building. Have a report that is customer specific, a monthly billing. The gals that will use this database all have Adobe Acrobat on their computers. Is there any way to take a report that is on the screen and convert it to a pdf file that can be emailed to users?

We have landscapers that do a fall clean up for us every year. They are in the country legally during the landscaping season, however, they do not necessarily read or write English. I want to post a sign that states "Landscapers - Do Not Cut Between The Signs". My knowledge of Spanish is about 10 words - can anyone give me a translation so I can make a sign in English and Spanish/Mexican. thank you.

I have a form that is based on a table. Each page of the form shows one specific customer's data. I would like to include a field on this form that automatically updates when I key in data - trying to create a "check and challenge" to total sales numbers so I can make sure the calculated total of the individual numbers match the total number keyed in (to catch any data input errors). I can create a field, but it is calculating all the numbers in the table, not just the one specific customer file. I tried a subform, but can't get that to work - what am I doing wrong, or is this not something that can be done?

When I move the mouse, it only highlights the cells I go over, and won't let me do anything within the spreadsheet.

I don't know what I did to create the anchor lock, so I don't know how to undo it. Closing Excel and reopening it does not undo the lock, I have to reboot the computer, then it's okay.