| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Same dates in Sheet1 put as one date in Sheet2
In the workbook Ive two sheets.
In Sheet1 ColumnA Ill put dates. Same date can be repeated to infinity. Row1 will be €˜Freeze Panes Sample: ColumnA Row1 Date Row2 01/01/2007 Row3 01/01/2007..................as one day in Sheet2 Row4 01/02/2007 Row5 01/02/2007 Row6 01/02/2007 Row7 01/02/2007 Row8 01/02/2007..................as one day in Sheet2 Row9 01/03/2007 Row10 01/03/2007 Row11 01/03/2007..................as one day in Sheet2 Row12 01/04/2007..................as one day in Sheet2 Row13 01/05/2007..................as one day in Sheet2 and so on In Sheet2 ColumnA I need formula or Macro or VB take new date inserted in Sheet1 and put same date to Sheet2 ColumnA to the next blank cell. Row1 will be €˜Freeze Panes In my case I need same dates in Sheet1 put as one date in Sheet2 ColumnA to the next available blank cell. Sample: ColumnA Row1 Date Row2 01/01/2007 Row3 01/02/2007 Row4 01/03/2007 Row5 01/04/2007 Row6 01/05/2007 and so on Thanks in advance. Sincerely, Igor. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
| Traffic Light Filter On Dates | Excel Discussion (Misc queries) | |||
| merging sheet1 to sheet2 | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Threaded Mode
