Search results

Hi Santhosh, have a look at Ron's web site there is sure to be something to help there. http://www.rondebruin.nl/win/addins/rdbmerge.htm

Hi, try this formula, it worked for me =SUMPRODUCT(1/COUNTIF(A$2:$A20,A2:A20))

Symmetry, nice

Just an idea, i have found in the past for excel 2003 You may have to put your own button on the sheet and then asign the code to it as cmd buttons from later versions dont seem to work with 2003. Hope that works for you.

Hi, did you try the code that Luke linked to?. I tested it and it seemed to work. Though I did sometimes get error 9 subscript out of range.

Prinz, would a user form be of any use or am I barking up the wrong tree? You could then send the answer to anywhere you choose and keep your answers in lists.

Hi, do you have a sample file with layout of what you need. It will help with a speedier reply if folks know exactly what you are trying to do. :)

Could you upload a file with your before and after layout. It may make it easier for someone to help you.

Hi, a sample file, with sample data and out put may make it easier for someone to help you.

Is this the same post crossposted in Windows secrets lounge and Mr excel

Maybe Copy, Paste special, Values?

:)

Maybe a short description of what it does would be helpful? :)

Lolo could you post a sample sheet, it would make it easier for someone to help with a solution.

Is there any reason why the sheets have to be in separate workbooks. It may be easier to handle if they were in the same workbook.

Karthik there s a lot of useful information about Userforms on Debra's Site http://blog.contextures.com/archives/2013/06/20/getting-started-with-excel-userforms/

Sorry i run excel 2003 so your procedure may be different. But alt F8 or Tools,macros or something similar will bring up a list of macros. Choose the one in "This workbook" then options, then a window opens with the option of asigning a shortcut key to the macro. Hope that helps a bit.

sub showuserform1() Userform1.show End sub Paste into a module. and asign a shortcut key to it. ? Is this the sort of thing you were after?

I dont know if this is relevant or not but I changed the PDF_DIR to PDFDIR in the following line to get it to work for me. Ialso had to add .pdf to the file name or it couldnt find it. PDF_Dir = "C:\Users\Acer\Desktop\package calculation\" 'Change to suit

I just had a similar problem with mine. Turned out to be my mouse pad was a bit soft... discovered that after buying new mouse :(

User forms are great for entering data in one place and then sending it off to relevant sheets. :)

Which words do you wish to count?

To have a userform auto open you can use something like this code. I think there are other ways of doing it also. Option Explicit Sub MYEXCELSHOW() UserForm1.Show (vbModeless) 'optional or modal End Sub Sub auto_open() Call MYEXCELSHOW End Sub

You use this to name a cell, or range of cells. You can then refer to the name in formulas etc. Just ask if you have any more specific queries :)

Maybe you could use a "User Form" and have your data stored on another sheet.