Insert/Add Current Date in Range

  • I have a worksheet where I load data into it everyday using code. Column A cannot have any blank cells. For this reason, depending on the amount of rows the worksheet loads on that day, I want to insert the current date for that range based on column A (primary columnn) using a Macro. The loaded data is appended each day. For this reason I do not know how to go abouts coding in new date as data is loaded on a new day.

    Thank You,

    Ravi Matharoo

  • Re: Insert date in range based on a primary column

    Hi you do not say where you would like the date, you do not say what the basis is for the new you want the date in A1 if colum A has data or in B1 if colum B has data.....etc?

    Adding todays date is quite simple, you can add this to your code so when you run it the current date will be put in cell A1

    With ActiveSheet
     Range("A1").value = "=Today()" 
    End With

    of course you can change the range to suit!


  • Re: Insert date in range based on a primary column

    Not too sure what you wnat here, but try these on a blank Worksheet

    Sub DateTime()
    Range("A1") = Time
    Range("A2") = Date
    Range("A3") = Now
    End Sub

    To remove blank rows, simply Sort.

  • Re: Insert/Add Current Date in Range

    more of what I need is date in the M column, I already have the date format that will be inserted, but its a matter of finding the days range that will be inserted. According to the amont of rows in the range, I want to insert my date.

    for example, if In day 1 there are X rows inserted into my worksheet, I need to find out how i would go abouts counting those amount of rows, and based on that, have the date insert into column M using a macro, based on the amount of X rows. So if there 40 rows inserted, I want to count the rows, and insert date for the 40 rows in column M

    In day 2 to lets say i have X rows append to my worksheet, I need to count how many rows were inserted, and based on that, insert the date based on those X rows.

    The rows are more or less inserted as a group using a macro. Gor each click I will get X amount of rows inserted in my sheet. What I need is, based on the click of a new macro, a way to find out how many rows are inserted for that group, thats why I mentioned that Column A willl always have data as it is my data lookup function. Maybe that can come in use in determining the row count, and from there insert the new date for the X amount of rows

    Thank You,

    Raci Matharoo

  • Re: Insert/Add Current Date in Range


    I think what we really need to know is how exactly you are inserting the data.

    If you already have code it shouldn't be a problem to just add to it to do what you want.

    Can you post the current code?


  • Re: Insert/Add Current Date in Range

    Raci, why didn't you relay the needed details 1st up? You may find it increasly harder to get help if you don't cleary explain your needs.

    BTW, if posting code please use code tags.

  • Re: Insert/Add Current Date in Range

    I will try to provide as much detail I can, so here goes.

    1) I have a workbook that contains 5 worksheets.
    - I use internet resources to load up the worksheets each day, all in table format.

    - I have a master sheet "Merged Data" where I am transferring all my data into each day using Match Lookup. "Symbol" column is the lookup column. All the data that is transferred to merge data sheet is appended.

    I clear the 5 worksheets on a daily basis.

    Click of a Macro provides the following:
    Here is the code I am using to merge the 5 worksheets

    - Is there a way, when In this code, as data is being transferred from each sheet to merge data sheet on a per row basis that the date is inserted in column "er" (or at the end of the row; either/or) in merged data sheet.

    For example, if in day 1 I click merge, X amount of data is inserted as well as the Day 1 date in column er (or end of the row); I want the date to insert based on the amount of "Symbols" I get for that day. In day 2, I get new data and click merge again, Day 2 should have now Day 2 date in column "er" of merge sheet again depending on the amount of symbols.

    - Right now I have an insert date function which inserts date into 2 worksheets. But in the merged datasheet, I can only merge using only 1 date column of the 2 datasheets. I can only link a column to another column in the datasheets; I suppose I cant link 2 date columns to 1 date column in the merged sheet

    So if I have a symbol aaa in sheet 1 and symbol zzz in sheet 2, depending on the link for the sheet I use to receive date data for merge sheet, it will only choose date from one sheet. When I click merge, one row will show date in er column and the other row wont.

    here is the coding that inserts date into each sheet seperately. But like I said, I want it to insert in the merge datasheet to avoid this situation.

    Thank You,

    Ravi Matharoo

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!