Search results

Gee, a senior moment I guess:-) I have it working now too. I apologize to everyone for wasting anyone's time. Have a great day PCosta and thank you again for being patient with me Wanda

Yes, I do get large space above Conc - Miscellaneous. Let me check settings. What you have is what I want and actually thought it would do. Thank you for your help. Wanda

Rows 18, 19, 20 and 21 are hidden on the Ops report. That is the one that I need to print and not leave the blank space for those rows on the pdf or hard copy of the report. I appreciate you taking a look at this. Thank you, Wanda

I have a report that will be printed monthly for over 200 departments so there are over 200 reports with data specific to each department. It is a budget variance report and only budget line items that exceed a certain percentage have to be explained in the report. The report is set up with...

Nebu, this is perfect. I really appreciate it. When I get help like this I take the opportunity to learn for the future so this is a great help. Wanda

I would like to set up a template for a monthly report that allows the user to drop in a financial report on the data tab (BC worksheet in attached sample) and have it populate the ops report on the first worksheet. The data report may have additional fields in some months so simple linking...

I am sure this is a very easy solution and my brain is just not working today. I have a attached a sample workbook that will be used for a very simple monthly financial report and a simple quarterly report. i am trying to make it very easy for the treasurer to complete this each month. My...

It worked this time. Thank you both for all of your help. I will drop it in my actual workbook and see how it goes. The other part of my question in my first entry at the top of this chain was is there anyway to capture the total invoice amount in a list as it loops through the different...

i set up a folder for PDF and then ran the test. i entered a date printed on the property worksheet but I can't find the pdf. Also, please explain how you did this so I will understand. I try to learn from the help I get here rather than just have someone do it for me. I also saw there was a...

I have attached the sample file that will print the invoices. This is dummy data but if you run the macro you will see it print the invoices for this very small group. This works great on the actual file. I just need to either be able to enter the code for the printer one time instead of 200+...

The sample file is just to get it to work as a test without over 200 properties being listed and printed. I just used dummy data. What the macro that was provided to me does is it starts on the Annual Invoice worksheet, looks up the property in the list in column o, gets the bed count (from...

I am so sorry. I attached the wrong file. Please see the file below. I have also replaced the first one above.

Help. See below for solution to prior request. This worked great to print out the 200+ invoices. Now, however, i have been asked if I can do two additional things with the invoices. One, create a total of the billed amount and two perform the same procedure on a second invoice in the workbook...

Help. This worked great to print out the 200+ invoices. Now, however, i have been asked if I can do two additional things with the invoices. One, create a total of the billed amount and two perform the same procedure on a second invoice in the workbook. So for the total of billed amount it...

Nebu, I just tested this and it works great. Thank you so much for your help. This will be an enormous time saver with over 200 needed and I learned something new. Wanda

I am trying to set up a way to produce an invoice for over 200 accounts working from the invoice template, a drop down list for each account and a worksheet that looks up values based on each account. I have attached a mini sample. on the invoice if you select one of the accounts it does a...

Thank you AJ. I was hoping for some ideas on how to do at least parts of it but it is a hard question. I appreciate your response. Wanda

I have an invoice set up in excel. I am going to prepare 209 of them and would like to streamline the process. I will have a list of 209 names that can be used for vlookup and i know how to do that. What i don't know how to do is take the invoice and each name and create 209 worksheets in the...

Thank you Hui. These look great and i will give one of them a try tomorrow. I do try to search first and just didn't use the right words this time apparently so thank you for giving me the links. I appreciate your help. Wanda

I have a worksheet that has over 8,000 rows and goes to Column BD. I would like to move data every time the value changes in column A. I will end up with 13 worksheets in the workbook each with the data just for that property. I have attached a very simple reduced copy of the worksheet. This...

Thank you Chihiro. This looks like a good solution. Thanks again for your help.

Thank

Chihiro, Thank you for your reply. i have uploaded a brief sample of what i need to do. The report is not formatted yet but i think you will see what i need to do. i also need to do a consolidated report that looks just like the property 1 and 2 reports but just adds the data together. it...

I have several budgets (76) in excel and need to produce a roll up report showing each entity and totals for each budget category, i.e. Repairs & Maintenance, Administrative, Marketing, etc. I already have a copy of each line item budget in a workbook and was wondering if there is a way to get...

Thank you. I will check out both methods. I really appreciate the help.