Replies

Thanks Hans. I have one problem with the macro above. If the last line has any info on it before the macro is run, it copies it which not what I had intended to do and the sum formula does not carry inserted cells. I still want the user to have the options of selecting facility type and activities in the inserted row. Any ideas or help. Thanks.

Thanks Hans again. That works.

Thanks Hans.

Thanks Hans.

I see what you are saying. The only reason I was using two columns was one contain the product number the other the description for that product.

Since we are in the topic, how come you can’t select more than one columm for the validation. I tried doing it base on the steps you guys gave, but if the validation has one or more columns it gives me an error message. I ended up with doing the concatenate function to have it work. Any ideas?

Thank you both.

Yes I am. I don’t have my password with me, so I ended up creating another account. By the way, I really want to thank you for all your help.

Hello Hans,
I was trying to use the code above to do what aaaofpmch wanted to do, but if there is a gap in the rows where there is an x, the columns do not get hidden. Any ideas as to why? For example, if I select row 2 column a,b,c,d,u, etc. The columns between d and u do not hide and there is a big gap in between them. Any help would be great. Thanks

Thanks Hans that worked.

Thanks LegareColeman. I made the mistake of editing a line in the coding and that is why it didn’t work. By the way. The statement below did what I need to. Thanks again.

You are correct in your assumptions. The active file is the one that we are in when we do the getopenfilename method. I am sorry to be such a pest, but If the sheet “SCO Positions” is already created, I thought the ‘Delete sheet if already exists will take care of it, but when I run the macro it stops at ActiveSheet.Name = “SCO Positions”. Any ideas? Regarding the sum, all I wanted to do is to sum column F from cell f1 to where the data ends. Thanks for all your help.

Thanks Coleman for the code. Regarding your questions:
1. The positions-Master file for Nov 05-Mary(copy).xls will be use as a base and it will be copy to next month but rename Dec 05. My fear is that since the code referes to a particular window(“position….”) which has the file name, it will give them an error. Am I wrong to assume that?
2. The column I want to sum is F. I will like to put it two rows below the last data entry.

Any Feedback would be great.

Thanks Hans it does what I need, but how about if I need to display all the columns for printing. Can we put it in the combobox?

Hans,

One last question. When there is no value in the formula (vlookup) #N/A appears. How can I have it so nothing appears if nothing is selected? Thanks.