Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Dates from One sheet to another
I am finishing up my workbook and am having difficulty having tw
columns of dates on my master worksheet copy onto my second workshee in my desired format. For example: In my primary worksheet I enter my dates in Columns "N" and "O". Ex. Entered First sheet: Column N ("First Date") is 31-Jan-04 Column O ("Date 2") is 28-Feb-04 On my second sheet am trying to have these two dates replicate i Column "N" as RESULT: Row N1 = 31-Jan-04 Row N2 = 31-Jan-04 Row N3 = 28-Feb-04 Row N4 = 28-Feb-04 Has anyone done something like this yet or can offer any suggestions? appreciate all the advice so far. The rest of the worksheet I have done in VBA. Having my othe information entered into my primary sheet has not been a problem excep for the date. *To get an idea of my overall goal is I building a workbook where dat entered into the "Primary sheet" replicates into four rows on m "Secondsheet" I have been able to write commands to do the basi elements of this but this date issue has been unsuccessful. Thanks again, Mat -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
When copying dates to another sheet the dates are different | Excel Worksheet Functions | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |