Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy row depending on value to new sheet
hi.
i have a workbook containing data for every day of the week. i want to export/copy data for monday to a sheet called monday, and so on for tuesday, wednesday, thursday, friday, saturday and sunday. any ideaS? cheers in advance! j davies |
#2
|
|||
|
|||
Hi j davies
Do you have a column with the day number or name ? Do you want to do this with code or manual ? -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message oups.com... hi. i have a workbook containing data for every day of the week. i want to export/copy data for monday to a sheet called monday, and so on for tuesday, wednesday, thursday, friday, saturday and sunday. any ideaS? cheers in advance! j davies |
#3
|
|||
|
|||
I have a column with the date in it on the source spreadsheet..the date
format is DD-MMM-YY |
#4
|
|||
|
|||
If you install EasyFilter you can do it very easy
http://www.rondebruin.nl/easyfilter.htm If you want a macro solution or want to filter manual you must first insert a column with a formula like this =C2 (c2 is the cell with the date) and format it like dddd (FormatCells.. Custom) You can filter on this column and do a manual copy or use a macro from this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I have a column with the date in it on the source spreadsheet..the date format is DD-MMM-YY |
#5
|
|||
|
|||
thanks for the reply, i dont think i have made myself very clear.
i have a source sheet which data gets inputted into daily...i would like to manually copy the data to 7 additional spreadsheets within the workbook. the 7 additional spreadsheets are called Monday, Tuesday and so on. the data columns range from E to AR |
#6
|
|||
|
|||
like to manually copy the data
Have you try to insert the column with the day formulas and use AutoFilter on that column ? Activate AutoFilter: Select a cell in your data table and use DataFilterAutoFilter to activate AutoFilter. Tip: Shortcut for the English version is Alt d f f In each header cell a dropdown will appear next to your field name. Click on the dropdown in the Day field (with the day formula) and choose the day you want Copy the filter result 1) Be sure that the active cell is in the data range 2) Press Ctrl * to select all data or use F5SpecialCurrent regionOK 3) Press Alt ; to select all visible data or use F5SpecialVisible cells onlyOK 4) Ctrl c or EditCopy 5) Select the worksheet 6) Ctrl v or EditPaste 7) Select the Source sheet with the filter 8) Press Esc 9) Press Alt d f f or DataFilterAutoFilter to turn off AutoFilter -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... thanks for the reply, i dont think i have made myself very clear. i have a source sheet which data gets inputted into daily...i would like to manually copy the data to 7 additional spreadsheets within the workbook. the 7 additional spreadsheets are called Monday, Tuesday and so on. the data columns range from E to AR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Name and email address from web sites to excel sheet | Excel Discussion (Misc queries) | |||
Copy Sheet and move to end | Excel Discussion (Misc queries) | |||
Copy from 1 sheet to another | Excel Discussion (Misc queries) | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |