Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to know of a way to select specific dates and corresponding
data and paste them into the next two columns. The column A contains consecutive dates(mm,dd,yyy) covering a 30 year period and column B contains data corresponding to each date. A way is needed to automate selecting and copying a specific range of dates w/data for each month of all years then pasting to columns C and D. ie: Select the date range and corresponding data for the range 06/01 thru 8/31 for each of the 30 years. Then paste selected cells from columns A and B to columns C and D. The 30 year time period will also vary in length from one study to the next. TIA Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Way to Automatically Select Data | Excel Worksheet Functions | |||
Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions |