Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 11-26-2014, 09:33 AM
Wynka Wynka is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2014
Posts: 1
Wynka is on a distinguished road
Default Trying to import specific data from one spreadsheet to another, without matching rows


I am trying to import data from one spreadsheet (Issues) to create tasks in another spreadsheet under specific titles. I have attached a sample spreadsheet.

EG: Issues spreadsheet lists various action items in random order under headings of "policy" "training" "IT" "Comms". I want all items under "policy" to import into the task spreadsheet for policy. I have been able to bring the data into the task spreadsheet using this formula:
=IF('Issue List'!A:A="Policy",'Issue List'!C:C,"")

The problem is that it keeps each issue item brought over in the same row it was written in the issue spreadsheet (so if it was written in row 4, it comes over into row 4 and leaves the previous rows blank.). Then, if I try to insert a row to create the tasks, the actual issue being addressed disappears.

I need to be able to have the issue import into the next available row in the task spreadsheet so that I can then breakdown the issue into however many tasks will be required and assign the resulting tasks to different people. This would involve inserting whatever number of rows needed to detail each specific task without the issue being referred to disappearing.

I sure hope someone is able to assist me with this. I've read LOOKUP, but that's beyond my capability in excel.

Thanks in advance!
Attached Files
File Type: xlsx Nat'l Roll Out Test Spreadsheet.xlsx (31.5 KB, 1 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using functions to restructure data in spreadsheet from rows to cols ghumdinger Excel 1 07-28-2014 08:06 AM
Import Excel spreadsheet calendar data into Outlook 2010 davesp Outlook 0 09-30-2013 09:26 AM
Inserting spreadsheet data rows as form fields in a document b3nz Word 3 03-31-2013 07:47 PM
Delete Blank Rows (Cyrillic Text in Spreadsheet ) dozd Excel 1 02-22-2013 03:24 AM
Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM

All times are GMT -7. The time now is 01:04 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft