Windows 8 Forums

Windows 7 Forum

Results 1 to 3 of 3
  1. 01-14-2012 #1


    jeffrys

    Senior Member

    Join Date : Nov 2011
    Posts : 102
    windows 8 x64 D.P.
    Belgium

    need help with Excel documents and Visual Basic


    well guys,

    do not know if the question is on the right board, but i need help with my Excel docu's.

    I need to copy 4 fixed fields (F6, F7,F8,G9,I51) into another Excel docu, but here these fields need to be in (C5,D5,E5,F5,G5) automatically.

    But the (C5, etc) are variable, so the next time it is (C6,D6,E6,6,G6) and i do not know the instruction to do so.

    Anyone ?

    Thanks alot


    Jeff
      My System SpecsSystem Spec
    Quote Quote
  2. 01-14-2012 #2
    vrosa's Avatar
    vrosa

    Senior Member


    Join Date : Jan 2011
    Belo Horizonte City
    Posts : 2,466
    Windows 7 SP1 x64, Windows 8 CP x64, Windows 8 Server CP
    Brazil au west australia 2


    If I understood right you will need to use the $A$1 sintax, this will make the formula fixed and field values wont change.
      My System SpecsSystem Spec
    Quote Quote
  3. 01-15-2012 #3


    jeffrys

    Senior Member

    Join Date : Nov 2011
    Posts : 102
    windows 8 x64 D.P.
    Belgium


    well Vrosa,

    in the first docu it is fixed, but has to be put in manually. These field values need to be transferred to the second doc and there the lines change one bij one.

    Otherwise i Always have to change manually both docu's

    but thanks

    Jeff
      My System SpecsSystem Spec
    Quote Quote
« wireless issues | Keybord Settings »