+ Reply to Thread
Results 1 to 1 of 1

Delete table/tablename, update values(this bit is done), create same table for new range

  1. #1
    Forum Contributor
    Join Date
    03-30-2017
    Location
    The Netherlands
    MS-Off Ver
    2016
    Posts
    141

    Delete table/tablename, update values(this bit is done), create same table for new range

    Hi everybody,

    I've got an excel file that basicly is a planning, it also generates a list of every activity so i could check if its ready to start.

    Here comes the problem. it takes data from planning Row after Row, if it would do Column after Column the dates would be good allready.


    # before starting to do everything as below Delete.TableName ("CheckListTest") 'this because after i updated values i want to create the same tablename back.

    The list is not really easy to read because it took data from the planning row after row, if it did the same but then column after column it would be fixed.
    The current macro copy paste the range ("F:Q"), this is where i put Y/N in case something is Y:ready or N:not ready. if i got N,N,N,N,N,N in range ("F3:Q3") it will copy this until the last column.
    would be awesome if it only created Conditional format over tablerange, if none of cells in range ("F:O") contains "n" make ("P") of that certain row color green.


    # make a Table named ("CheckListTest") with range("A2:Q, till last row Counted from E") inclusive headers in row 2 (for sorting the activitys on date)

    Anyone who could help me with this?, all i need done is:
    - deleting the table, Keep the headers for new table.
    - Let the allready written piece of macro update values
    - create new table with same name as before
    - conditional formatting on ("F:P")

    Here my file definitieve planning template 05-04-2017.xlsm

    If you want to upload it back just delete Row 6 and down on the sheet "Startklaarlijst" this will bring filesize down :d

    I dont even know if this is possible, but sometimes it happens to be the planning changes.
    In the list "Startklaarlijst" as in my file, there could be alot of tasks marked with y/n allready in range F3:O
    Is there any work around to save those y/n linked to the task ?
    Last edited by 323428; 04-06-2017 at 05:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete damaged lines from a table and update the table
    By hlynur11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2017, 02:24 PM
  2. VBA to create/update pivot table from other workbooks
    By KOstey80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2017, 11:17 AM
  3. [SOLVED] Create drop down list with range of values that is exact match from a table
    By glenwalcuch in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-22-2015, 03:09 PM
  4. [SOLVED] Create code to update named ranges in a table. Table contains Many Name Ranges
    By Calio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 11:13 AM
  5. INSERT INTO tablename using sql [dynamic table?]
    By swill008 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2013, 10:22 AM
  6. create league table :: enter result :: update table
    By Eng.Soly in forum Excel General
    Replies: 2
    Last Post: 12-27-2008, 06:31 AM
  7. Create Table; Update Table: MS Query
    By astrodon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2008, 06:39 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1