Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Control pasted/imported data to use only ODD or EVEN rows
I want to move data from access 2000 to excel
I want to paste or import. May I tell excel to only accept one paste to use ODD rows, the the second paste to use even rows? I have spit data in access queries so I can use two pastes,exports. I have 5000 rows to do per paste. Maybe fifty columns The data in each paste will have identical columns and information. example; Joe, Smith, address, 1st car info (red blue black) Joe, Smith, address, 2nd car info (red blue black) Mary Poppins, address, 1st car info (red blue black) Mary Poppins, address, 2nd car info (red blue black) If you have a solution, my email is |
#2
|
|||
|
|||
I haven't seen a follow up that gives you what you want so maybe you
can try two pastes then sort on one of the columns that is the same in both queries? If you don't want to reorder the records then try something like this: Assuming AY is first open column, row 1 is labels, and column A holds a value that is the same for records you want together, but different in all cases you want seperated, type 1 in AY2 In AY3 =IF(ISNA(MATCH(A4,A$2:A3,0)),INT(MAX(AY$2:AY3))+1, MATCH(A4,A$2:A3,0)+0.1) Copy AY3 down then sort on Column AY On Wed, 2 Mar 2005 09:36:21 -0800, "john C" wrote: I want to move data from access 2000 to excel I want to paste or import. May I tell excel to only accept one paste to use ODD rows, the the second paste to use even rows? I have spit data in access queries so I can use two pastes,exports. I have 5000 rows to do per paste. Maybe fifty columns The data in each paste will have identical columns and information. example; Joe, Smith, address, 1st car info (red blue black) Joe, Smith, address, 2nd car info (red blue black) Mary Poppins, address, 1st car info (red blue black) Mary Poppins, address, 2nd car info (red blue black) If you have a solution, my email is |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I control to which cells a user adds data? | Excel Worksheet Functions |