+ Reply to Thread
Results 1 to 2 of 2

Copy data from column to sheet database (Autosense system date and copy to Calender sheet

  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Copy data from column to sheet database (Autosense system date and copy to Calender sheet

    First of all I got an idea from Kasan with a solution he did for someone on this site but my requirements is different as I want to send all the data in column A to a calender database in sheets(database)

    Hi I need some advice how to do the following. I have an excel sheet Column A with data which I want to add to a sheet called database.....you will see its a calender with columns underneath the days.

    I need some advice to do the following

    Is there a way to Link sheet A to autoselect date so it will use the current system date and copy the data in column A to the date in the Calender sheets(Database). I want to copy all the data in column A to todays date in Sheet Database under todays date.....a combobox wont work but a list box ????

    If someone can point me into the right direction how to achieve above it will be greatly appreciated. I know excel is not a database but its a simple solution to not goto access database route
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Copy data from column to sheet database (Autosense system date and copy to Calender sh

    Apologies my browser double posted can an admin please delete one thread....Thank you

+ 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. Replies: 9
    Last Post: 06-27-2016, 01:02 AM
  2. Copy data from sheet1 column with dynamic date, and copy data to second sheet column
    By Renaliiii in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2016, 04:44 PM
  3. Macro to copy & paste data into new sheet depending on column header (date)?
    By BobbyH89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2015, 03:44 PM
  4. Replies: 5
    Last Post: 03-31-2013, 09:24 AM
  5. Copy column from one sheet to another sheet based on date
    By thuddleston11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-06-2012, 04:30 PM
  6. Copy column data on one sheet to row or column date on another sheet based on user in
    By soready42012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2012, 12:03 AM
  7. Replies: 2
    Last Post: 07-31-2011, 05:00 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