mani_singh
Well-known Member
- Joined
- Jul 24, 2007
- Messages
- 583
hi everyone,
i have a problem in that i need a macro command to:
go to a table called "tier control" and copy some data into a table called "datatable"
- on "datatable" i input a value into column B, this value needs to be found in the table on "tier control" column A
- it then needs to copy from that table row cols A,D,E and F.
- and copy them into the "datatable" row originally typed into with the first value
- in the row the data must go on cols O,P,Q and R
and thats it!
i hope someone can give me a hand with this prob!
thanks
i have a problem in that i need a macro command to:
go to a table called "tier control" and copy some data into a table called "datatable"
- on "datatable" i input a value into column B, this value needs to be found in the table on "tier control" column A
- it then needs to copy from that table row cols A,D,E and F.
- and copy them into the "datatable" row originally typed into with the first value
- in the row the data must go on cols O,P,Q and R
and thats it!
i hope someone can give me a hand with this prob!
thanks