FromTo data in Line List

[Viper]

I'm in dire need of some help and my VB sucks.:(
How do I get the from and to data in the excel report to populate in there own columns?

[dave]

open your vba (alt+f11)

open your FromTo macro module

search for
Set objFromToCell = ThisWorkbook.ActiveSheet.CellsYou will see the numbers
(objCell.Row, 13) just after that. Change that number to whatever corresponding cell you want.

[Viper]

Thanks,

Not sure if I'm just being stupid but hows that going work for me when I want to do the following.
Say I want the TO data starting in column D7 and the From data in Column C7.

[dave]

change the number to 3 and 4 respectively.



If (item.bucketType = CONST_From) Then
Set objFromToCell = ThisWorkbook.ActiveSheet.Cells(objCell.Row, 3)
ElseIf (item.bucketType = CONST_To) Then
Set objFromToCell = ThisWorkbook.ActiveSheet.Cells(objCell.Row, 4)

[Viper]

Great stuff will give it a bash and let you know.

[smartman]

hey Dave, when did you join twitter? i am following you there now :)