Consulting

Results 1 to 4 of 4

Thread: Copying and pasting values into a table below the previous entry for many days

  1. #1

    Question Copying and pasting values into a table below the previous entry for many days

    I have an automatically feeding data stream from our accounting program which automatically updates daily.
    I want to copy and paste the data into a table in order to create a line-graph of our business metrics.
    i need to craft a vba query to automatically copy and paste certain cells into a table, each day below the other i.e. on monday it needs to paste into A1, on tuesday - A2, wednesday A3 etc.


    Can anyone write this for me?

  2. #2
    please help me
    My deadline is encroching.

  3. #3
    VBAX Expert
    Joined
    Sep 2016
    Posts
    783
    Location
    cells(rows.count, "A").end(xlup).offset(1)

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,704
    Location
    I have an automatically feeding data stream from our accounting program which automatically updates daily.
    Tell us about that Stream... What format is it in? What is the mechanism you receive it by? What is it's structure?

    i need to craft a [] query
    Tell us about the Data Base... What is the Connection String? What is/are the names of the Tables of interest? What are the Fields of interest? What is the relationship of the Fields to the Columns/Headers of the Table you want to create?

    Without knowing all that, mana has already provided the best answer we can, given the paucity of information in your post.

    OK, I can expand on mana's code a tiny little bit
    For each day
       Sheets("SheetName").Cells(rows.count, "A").End(xlUp).Offset(1) = Range(datastream)
    Next
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •