JKB
12-11-2015, 01:03 AM
Hi everybody!
Im in a bit of a hick up. I have two columns in a pdf, which by using VBA im copying into excel. My problem is that when im doing this it pastes the data in as an entire row, i.e. if this is my pdf with two columns X,Y:
X Y
X Y
X Y
X Y
When pasting this into excel i get
X
Y
X
Y
X
Y
X
Y
My problem is that i would like to assign the data from each column with a 0 or 1 depending on which column it came from, and if the two columns are not exactly the same length, i have a problem (Else it would ofc. just be every second value assigned with a 0 or 1)
I think i might be able to solve the problem, if i could somehow know how many observations i have in each column in the PDF. Does anybody have a better suggestion to solve the problem, or by any chance know how i can get the amount of rows in each (or just one) column?
Hope someone can help! Again it's not a problem to get the data into a sheet :)
Cheers!!!
Im in a bit of a hick up. I have two columns in a pdf, which by using VBA im copying into excel. My problem is that when im doing this it pastes the data in as an entire row, i.e. if this is my pdf with two columns X,Y:
X Y
X Y
X Y
X Y
When pasting this into excel i get
X
Y
X
Y
X
Y
X
Y
My problem is that i would like to assign the data from each column with a 0 or 1 depending on which column it came from, and if the two columns are not exactly the same length, i have a problem (Else it would ofc. just be every second value assigned with a 0 or 1)
I think i might be able to solve the problem, if i could somehow know how many observations i have in each column in the PDF. Does anybody have a better suggestion to solve the problem, or by any chance know how i can get the amount of rows in each (or just one) column?
Hope someone can help! Again it's not a problem to get the data into a sheet :)
Cheers!!!