| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If date Then Paste.....
HI all..
The "name" is a file for each office "South_Office.xls, North_Office.xls, ...up to 8 files), the target range is "C3:G3"... and paste data in one row : "Target.xls" -A---B----------------C-------D-------E------G- 01--South_Office----"G7"-----"G8"----"G10"---"F2" 01--North_Office----"G7"-----"G8"----"G10"---"F2" 01--Central_Office--"G7"-----"G8"----"G10"---"F2" 02--South_Office----"G7"-----"G8"----"G10"---"F2" 02--North_Office----"G7"-----"G8"----"G10"---"F2" 02--Central_Office--"G7"-----"G8"----"G10"---"F2" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date changes from copy to paste | Excel Discussion (Misc queries) | |||
| Date Cut & Paste Issue | Excel Discussion (Misc queries) | |||
| paste web without date format | Excel Discussion (Misc queries) | |||
| Date copy, Paste error | Excel Discussion (Misc queries) | |||
| paste by date | Excel Discussion (Misc queries) | |||
Linear Mode
