LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 26th 14, 08:11 AM
Junior Member
First recorded activity by ExcelBanter: May 2014
Posts: 2
Default Data copied to dated columns for each day of the month

I have been racking my brains and reading tons of posts but none about what I'd like to do.

I have a workbook set up with 12 seperate tabs, one for each month. In each tab I have seperate columns with the dates of each day of the month in row 1. I also have another tab set up for todays sales using =TODAY() in B1, A2 account number, A5 to A15 product codes, B5 to B15 corisponding products (to the product code).

When sales are made for example on 5/25/2014 I would like them to automatically be entered in to the corisponding sheet (May) and column (5/25/2014) for that day, so I can keep a record of each days sales and product codes for the entire month all in Mays tab.

I'd like to do this using a formula if possible. Can anyone please help me?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check inputdate, then retrieve data to fill in chart from dated co Kozmik Excel Worksheet Functions 2 February 9th 10 05:15 AM
How to draw a regression line on 7000+ dated data with Excel 2007 Gordon Lee Charts and Charting in Excel 2 October 16th 08 12:44 AM
Hyperlink imported data into worksheet with dated formate Derro Excel Worksheet Functions 0 October 13th 08 03:53 PM
Charting Dated Data Marsh Charts and Charting in Excel 1 January 7th 08 06:46 PM
Automatically creating the correct number of dated columns Struggling of Essex Excel Discussion (Misc queries) 3 April 25th 05 05:56 PM

All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017