The red indicates wordwrap. The mc="c" is on a separate line. then change the c to suit your column which was c... Then correct other wordwrap problems by going to dlr = Workbooks("destfilename.xls").Sheets("sheet2").Cells(Rows.Count, and use the delete key to bring up so all is on ONE line. Of course, change the filename to suit. "K").End(xlUp).row + 1 If you're new to macros
Don, I tried yours, but I got a lot of red. Some of the codelines got broken I think, but it's having problems with the initial Sub line Sub dounique()mc = "c" Is that supposed to be: Sub dounique() mc = "c" And again, the line Workbooks("destfilename.xls").Sheets("sheet2").Cells(dlr, "k") is in red. I just don't know anything about VBA to know what the problem is. Could
Bernie: Your macro is moving everything fine, but what I meant by different numbers of rows is simply this: say you end up with 5 unique values in Book1, Col C -- that shows up in A1-A5 of the new sheet as: 34 53 90 197 8 Then, you move to Book 2, Col C, it has 3 unique values within itself, 53 700 8 It should then tack these onto the new list in A6-A8, but really, it should
On 11 Lug, 16:03, mysh...@gmail.com wrote: Ho diverse tabelle in diversi database che hanno molti campi in cumune. Una tantum è necessario "raggruppare" i dati contenuti nelle varie tabelle per fare delle verifiche: Ho creato un db con una tabella nuova che contenga i campi di cui ho bisogno, ho collegato le tabelle che mi servono dai vari DB e, tramite query di accodamento, ho riempito
