| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy certain rows from one worksheet to another
It appears that you only have 6 different record types ("Investigation
Div","Anonymous Tip, "Pattern Claims","Staff Referral", and all others ("Blank")). I would still suggest my original idea of simply doing 6 separate exports from Filemaker Pro, then import those data extracts into Access. You can export only the fields that you need for each record type. As you mentioned, you only have about 500 rows of data for each record type. You will avoid accidentally corrupting your data by NOT using Excel. (Clicking on a column heading in Excel, then sorting will sort only that column, corrupting the data, for example! Believe me, I have accidentally done this myself!) -- Regards, Bill Renaud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
| Copy rows to another worksheet | Excel Worksheet Functions | |||
| Copy Rows From Worksheet Into Another Worksheet Same Workbook | Excel Programming | |||
| Copy Rows With Same Value into a new Worksheet | Excel Discussion (Misc queries) | |||
| Find all rows of a color and copy those rows to a new worksheet | Excel Programming | |||
Threaded Mode
