Im Stumped!!

[zwalker4147]

Referencing the table I have created below. I am trying to get my inputs from column (a) and (b) to reflect in the dates corresponding in the adjacent columns. After the inputs have been reflected, I will change the dates in the input columns and then change the inputs to reflect on the new dates.

The problem I have is I need to change the dates on the input columns(cells) so I can input data on a certain date, I need the information to stay in the receiving columns (cells) even after I change the dates.

(EXAMPLE) On 4/28 and 4/29 I need to input data, that will reflect on the receiving cells, when 5/10 and 5/11 come to pass I may need to change the data on those dates, but I don't want to loose the inputs from 4/28 and 4/29.

The dates are arbitrary, and they will continue for months. And I don't want to have to scroll over to find certain a certain date. I am pretty good with excel, but this has me stumped.

Thanks in advance for the help
[TABLE="width: 500"]
<tbody>[TR]
[TD]4/28(a)[/TD]
[TD]4/29(b)[/TD]
[TD]4/28[/TD]
[TD]4/29[/TD]
[TD]5/10[/TD]
[TD]5/11[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[offthelip]

Your requirements are totally unclear:
What do you mean "Reflect" that is what mirrors do, not Excel. Do you want to copy the dates across, just the first time they are entered? This could be done with VBA, also you state:

I will change the dates in the input columns and then change the inputs to reflect on the new dates.

What inputs are you going to change.

 

[zwalker4147]

Sorry for the unclear message. What I am trying to say is... I have two columns (a) and (b) that I input information (represent by "x" in my example). I am trying to track my products sold on certain dates. The dates in column (a) and (b) are the days I am trying to input the information. The following columns in the worksheet are where the all the sales information is stored and calculated. I want to be able to input information on the date I have in columns (a) or (b) and have the information put on the respective date else where in the worksheet.

I hope this clears it up, I wish I could physically show you what I am trying to do.

 

[offthelip]

Your requirements are still poorly defined, i.e you haven't stated where you want the the data copied to just "elsewhere in the worksheet"
So just to show you how to get started this routine will copy the whole of column A or B to the next free column on the same sheet whenever you enter data into column a or B
This needs to be put in the Worksheet change event for the sheet you where you want this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not (Intersect(Target, Range("A2:B10000")) Is Nothing) Then
colno = Target.Column


Lastcol = Cells(1, Columns.Count).End(xlToLeft).Column
Application.EnableEvents = False
ActiveSheet.Columns(colno).Copy Destination:=ActiveSheet.Columns(Lastcol + 1)
Application.EnableEvents = True


End If


End Sub