Search results

You could also post a file with the layout you are hoping to achieve.

Do you have a sample file you could post with the layout that you require and a sample of your database etc.

Do you want a user form to enter the data and then send it to your table?

If you are using the "subtotals" you may need to select "visible" cells only, then paste special values.

There is a useful little search box mentioned over at http://windowssecrets.com/forums/showthread.php/151221-VB-Corner-for-Excel-Learn-Visual-Basic-VB-Code-Repository Posts 63 and 70. Please delete this post if it is inappropriate.

What do you do if you have a question, so search the posts for a solution, find one that seems to be the correct topic but run into a problem. You cant post in that thread. If you post a new thread you will be asked if you have done a search as this topic has been covered before. Just...

I second bobhc's recommendation, if you have any problems just post back. User forms are fun.

Have you tried Vlookup?

That would be great but dont forget some of us dont know enough excel to always know what we should be looking for and sometimes need a pointer from an excel ninga :)

OOps I tried doing this and obviously didnt get it quite right as my whole sheet changes to the number of the column selected. Luckily I was just testing on a copy of my sheet, I must try harder :) By the way Narayan thanks for the detailed explanation, I will go back and do it again.

Best be having one for me as well. Happy birthday!

Hi is your combo box property "resize" set to auto, or true?, I think that makes the size vary. HTH L

Spreadsheets make work fun.

kimdotcom lives in NZ

@John Hi This is my latest 2003 version including Lukes code and a few more mods. Let us know what else you need. http://dl.dropbox.com/u/20269099/sunny2.xls

@John, ok will go find it. You should also be able to do what Luke has sugested. Its no problem to have the data entered wherever you want.

Sunnyp Did you try viyjays code? I have a version for excel 2003 if you need it.

Hi Sir JB7, Great file. I did have to rebuild the buttons and check box as converting the file for excel 2003 seems to disconnect the code from them. I also got a couple of error messages. One about declaring constants which went away when I put in const xlSortOnvalues = 0, but then it stalled...

:) Cheers.

Hi Sir JB7, Many thanks for your help, but where have you hidden the file?

Hi SirJB7 as you can see I am not very experienced with code and was just trying different options to see if I could get it to work. All I want to do is copy the entry form, named range "entryform" which is on sheet "BlankEntries" to the other sheets with names ending with .txt. I will put in...

Hi, Thank you Luke. This is what i am working with so far but nothing is getting pasted to the .txt sheets. The code just goes straight to End If after "Then" My "Do something" is not working. `Dim ws As Worksheet Application.ScreenUpdating = False...

Hi I have imported several text files and saved them as worksheets in a workbook which contains other sheets as well. The new sheet names all end with .txt. I would like to copy a named range from another sheet and paste it only into the sheets named ....txt. I have some code which will paste it...

Brilliant , thank you, works a charm. I had been trying to put in the workbook name and obiously not doing it quite right as it didnt work

Hi, I have been using Ron de Bruins code (below)to convert multiple text files to excel sheets in a newly added workbook. What I would like to do is to be able to add the worksheets to an existing workbook if possible. Help with the code for this would be much appreciated, Thanks...