Search results

Hi! Thanks for all the thinking with me! Seems that I am stuck with the slow running time. So I tried to get some answers on the googleforum for googleforms. The best solution for me now is to force the region settings of the google spreadsheet to US. With this I can also force users with a...

Thanks SirJB7! I had something similar done... As you probably see I tried to change the format afterwards. Why? The numbers are seen as text, but my solution takes ages to execute and a error pops up when there are letters involved instead of numbers. I hope you have a better idea? Sub...

Hi, I am busy with a lot of data from different users. They fill in some numbers, but some use the dot from the nummeric keypad as seperator. where it needs to be a comma. For this I use google forms, It almost doing the trick but every user is using it differently. ", " or "." The numbers...

Thanks Smallman! It seems to do partly the trick. I am able to move sheet and keep all the settings. Although this means I have delete every week all the other sheets when I perform the 'move' in VBA. It will also create another problem. I am using this part of code on the sheet and...

Hi, I have indeed 2 workbooks and would like to copy a worksheet from workbook A to B. I guess the biggest problem is the defined names. The defined names in workbook A are dynamic (making use of the offset and count functions) and work fine in workbook A. The chart is on the same worksheet...

Hi, I have a weekly workbook with a chart based on dynamic named ranges and have to copy the sheet to another workbook, but when I try to do this I do not get the right links in the chart source. Can you point me out in the right direction? Thanks!

Sweet! Thanks Narayan! It seems to do the trick! :-) I have made a little modification on the last row. Sub removedub2() Dim r As Range, n As Long, a() lr2 = Range("T" & Rows.Count).End(xlUp).Row ' define lr2 as the last row of data ReDim a(1 To lr2 - 1, 1 To 1) With...

Hi! For 2010 there is this piece of removing duplicates ws.Range("A2:A" & lr2).RemoveDuplicates Columns:=1, Header:=xlNo Now I need it for 2003 but it does not seem to work for me. Dim r As Range,n As Long, a() Redim a(1 To lr2 - 1, 1 To 1) With...

Wow... at first I thought nothing is happening... But SirJB7. You just amazed me with this stunning piece of art. It works so quick that it is even more then perfect. this is exactly what I need. BIG THANKS!!!

I tried to modify the example from the post from Hui. But got stuck after the first copied row. I created an example file: https://www.dropbox.com/s/6loixt0kbf7nbkq/samplerows.xls Thanks SirJB7 for taking a look.

Thanks Hui, tried the example file. It seems to be almost doing what I need. Although I am not sure about what I try to do is right. As I want to cut the rows and paste it on the other sheets. I get an error at: "Selection.PasteSpecial xlPasteValues" when I try to change the line with...

Hi I am trying to split up data. I need to cut and paste rows from the sheet DUMP to 2 other sheets. In column AR the rows are marked with Inbound, Outbound or E-mail. I need the rows with Outbound and E-mail in the sheets Outbound and Email. But they have to paste rows in the next empty row...

Wow! Thanks! It seems to be working in the testing folder! I am going to test this out in production! Thanks a lot. This really saves me a lot of trouble!!! This was bugging me for such a long time!!!

Thanks! Here is the link: https://www.dropbox.com/s/1gvmfqt2299wj7u/CCC.zip There are a lot of formulas that would slow down the file. So make sure Calculating is on Manual.

Thanks Luke! I just do not get it to work... :-( Is there a way I can post you an example of the xls files. I have it zipped and should be around 421 kB I think you would understand the situation a bit better.

Luke's suggestion is not working for me. I am getting a Compilation error. something about Sub or Function is not Defined. And then it highlights blue the part of Worksheet from the code: <br /> FileName$ = Worksheet("Annemieke de Jong").Range("B2")<br /&#62...

Thanks Luke and Narayank! I'll try to explain the situation. I need help with copying a range of cells (E9:Q30) from several workbooks in a folder "CC" to a main file. I'll try to explain any further conditions. * The main file contains a main sheet for a particular week and has several...

Hi, I still hope to get some help with retrieving data from a particular sheet from a particular workbook. To make it clear... The workbook name is located in on sheet "Name 1" and in Cell "B2". The name of the needed sheet will be located on the same sheet in cell "B3". I need to apply...