Declare datatype

Hi All

I am defining a for loop and copying values from one worksheet to another.
Matching field is e.g. 1,1.1,1.1.2 , 1.2,1.2.1.......
whts happening is, after copying till 1.1.2 next value shoul dbe 1.2 but it goes back to the values of 1.1.2 instead of 1.2. is there any function available i could check this with?

Hi.
i have 2 files. one is source and the other one is target. i am trying to import data from source to target. can anybody suggest macro code to do that?

I have got a field with values 1.1.1,1.1.2 and so on. i want to declare a variable to hold these values with 2 decimal points, wht shall i use?

Hi

Can you tell me how 1.1.1,1.1.2 translates to a number? What is it meant to represent? Double or Currency are the obvious choices for a number with 2 decimal places.

Richard

hi

its just a value as in table index.

I have attached 2 files. Source file from where data is coming and target where its going.

Are you just wanting to do a straight copy & paste from the source.xls to the traget.xls? You don't need to hold the data in a variable in which case - you can just execute the copy eg:

Please Login or Register  to view this content.

Amend the workbook names, sheet names and ranges copied from/to for whatever is appropriate.

Richard

Threads merged.

Renu, please stop opening new threads on the same topic.

So far, no one has a clue what you're trying to do. Maybe you could take a deep breath and explain clearly.