Search results for query: *

I will try that...thank you!

In order for my output file to be loaded into another system, the "account numbers" can not be duplicated. Although one "account number" may be the same as another "account number" listed, the file does not contain duplicate information. I would like to automatically add a space (preferably)...

Yeah, the problem is that when you run the recorder and activate all of the charts on the page and the select print, it prints the worksheet as it normally would without any charts activated.

This will print out the sheets, but the charts print out differently. If you want to print a chart as 1 per page, you have to activate the chart first. This will allow the chart to print on one page. If I have 3 charts on one workbook, I would like to have each one print up as its own page.

I have a workbook with the first worksheet as a homepage. Then I have about 10 other worksheets that have 3-4 charts on each of them. I am trying to create a macro that will allow me to click on a button on the "Home Page" and have it print all of the charts on a specific worksheet in one...

You rock! Thanks!

I am needing to have every sheet in my workbook named after a specific cell reference. For instance, I want every sheet in the workbook to be named after the text that is in cell A5 on that worksheet. I need it to go through all of the worksheets in the workbook and perform the same task. Can...

Have you ever used the filter option on the form properties? Is that an option?

Where do I find the wizard?

I would to use one form to display the data for the user. However, I would like the data to change based on the department code selected. How can this be done? Thank you in advance!

I have built a database (MS97) that has been in use for quite some time now. I realized that there was a problem with my input mask today when a user emailed me. The current input mask is to make sure the first letter of the name is capitalized so it is <L>??????????? I need to be able to...

I am wondering if it is possible to add new text boxes to an existing PDF File using Adobe Acrobat. I can use the Text Touch up Tool to modify the existing text, but I am needing to add new lines of text in addition to the existing text. Please advise if you have any suggestions. I...

That worked beautifully!!!! Thank you so much for all of your help! I really appreciate it!

For my real sheet I am working on I am actually using different cells than A1 and so on, but I was trying to make it easier to understand. Could you please take a look at the following code I have so far and let me know what is wrong. I got an error on the Range(&quot;B5&quot;).Copy _...

Thank you very much for your help, but I have one last question.. It turns out that there is one other cell on each sheet that will need to be copied to the summary sheet. This cell is not located next to the other cells. So, I will need the contents of A1 copied to cell A9 in the summary...

Sorry...I got that part fixed by adding the quotation marks around B9, but now I have another error r = w.End(xlDown).Row Gives me an error of Run-Time Error 424: It says object required. It copied the information from the first sheet and pasted it, but then it gave me the error. Thanks for...

I got an error on this part of the code: With wsSummary.Range(B9) The error was a Run-time error '1004': Application-defined or object -defined error

It worked great. Thanks for your help..

Skip, The source range on each sheet is the range B6:B12. The data will then need to be pasted using paste special to make it transpose into range B9:H9. After it pastes it, it will need to either insert a row so that the next sheets data can be inserted in the same place on the summary...

Sorry I didn't include enough info. Every sheet, except Summary, has the same format. The same group of cells from each sheet(except Summary) need to be copied and inserted into the Summary sheet, one group of cells on top of the other. The code needs to start with the second sheet and...