+ Reply to Thread
Results 1 to 3 of 3

Select which column & row to paste value according the date

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    10

    Select which column & row to paste value according the date

    Hi,

    I spent my day on it and no way for me to understand how to it.

    I need to create a data base from figures extract everyday. I would like according the date to copy the figures in the sheet "Extractor" to paste in the column corresponding to the day of today in the sheet "Database". If possible as well, the figures of the dates before today must be delete (in the color tab)

    I join a sample of what I have. I tried with the indirect function, but didn't find how to keep the figures of the previous dates.

    Thank you so much for your help!!

    Extractor.xlsx

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select which column & row to paste value according the date

    Which sheet is extractor and which sheet is Database?

  3. #3
    Registered User
    Join Date
    06-04-2014
    Posts
    10

    Re: Select which column & row to paste value according the date

    Sorry it didn't work properly

    First sheet is extractor, everyday new figures
    the second is the data base. Numbers in column equal the day of the date of extraction

+ 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. Select (one) Row where a column has a value in it. Paste one row below it.
    By saturos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 01:09 AM
  2. Select the last row in a column with data nd paste the value in the rest of the column
    By Sheldon Brooks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2013, 05:33 AM
  3. VBA - Paste / Select Column / Currency / format
    By rik1313 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2012, 04:49 AM
  4. VB help SELECT COLUMN / PASTE FORMULA'S
    By XL XL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2010, 09:14 AM
  5. Select empty column & paste - Help please
    By saziz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2005, 02:55 PM

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