Windows 8 and 8.1 Forums


need help with Excel documents and Visual Basic

  1. #1


    BELGIUM
    Posts : 503
    WINDOWS 8.1 x64

    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

  2. #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

  3. #3


    BELGIUM
    Posts : 503
    WINDOWS 8.1 x64


    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

need help with Excel documents and Visual Basic
Related Threads
Excel data lost in Software and Apps
I've got a Samsung laptop with Windows 8, and I have been working on an Excel document every day for a while. Today I came to my parents' house and logged onto their internet for the first time. I then worked on my spreadsheet, clicked save, closed it and attached it to an email I sent. I went back...
Hi there I'm just messing around a bit with Visual Basic - I just want to use EXCEL (mainly) and a couple of really simple Windows stuff. I can't be bothered with C# or .NET -- I'm not (nor intend to be) a professional programmer -- but would like to have a go with some small applications and get...
Win 8.1 eliminated word and excel. I just updated to 8.1 from win 8 and have alot of documents and spreadsheets from win8 office starter package. What programs can I use to open and edit these. Also, what programs are compatible to create docs and spreadsheets in win 8.1 to be opened and edited in...
count if excel in Software and Apps
in excel if type "=conuntif(a1:c10,"a") it will count all the cell with a in but is there where so if the cell had aa it would count that cell as 2
Is there a quick way to switch between a web page I am looking at and an open excel or word document or do I have to go via the start page every time ? Thanks in anticipation
Windows 8 is the default and only OS on this laptop. Please do not suggest restore or backups - they do not exist. I am trying to reinstall a fresh Windows 7 back into this laptop for dual boot purposes. I have a Win7 ISO all ready to go on a flash drive. The problem is... I cannot get the...
Eight Forums Android App Eight Forums IOS App Follow us on Facebook