User Profile

Collapse

Profile Sidebar

Collapse
Jan Gronqvist
Jan Gronqvist
Last Activity: Nov 10 '10, 05:57 AM
Joined: Aug 27 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Jan Gronqvist
    replied to Update data in Excel with VBA
    Yes! thank You. I've been working with this problem for nearly 3 months. This code works perfect!
    See more | Go to post

    Leave a comment:


  • Jan Gronqvist
    replied to Update data in Excel with VBA
    Hello!

    There are 5 columns in this example. In this example I want to update the data for Customer 1 (new data in columns Col b and Col c).The new data is entered in the grey field above the database.

    I have this code that manages to update only one row (the first). Before I run this macro another macro runs a "SORT" macro so that I get all records with (in this case) CustomerID 1 in rows 1- 10 (if there is...
    See more | Go to post

    Leave a comment:


  • Jan Gronqvist
    started a topic Update data in Excel with VBA

    Update data in Excel with VBA

    I have this Excel spredsheet with 4 columns. In colum A i have "CustomerID " in col 2 Customer in 3 data.

    My problem is that the same CustomerID may appear att several rows, because the customer data may appear several times. Now i'm seekeing for a VBA code that manages to update those rows containing a certain customers data.
    See more | Go to post
No activity results to display
Show More
Working...