# Moving specific data into separate worksheets

Solved/Closed
Related:

- Moving specific data into separate worksheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to insert picture in word without moving text - Guide
- How to find specific words on a page - Guide
- Data transmission cable - Guide

## 7 responses

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Apr 16, 2010 at 02:05 PM

Apr 16, 2010 at 02:05 PM

Steve

Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.

Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.

Thanks for the swift response rizvisa :) This is how I forsee it, really hope you can help!!

https://authentification.site/files/21978173/ExampleDoc.xlsx

Thanks again,

steve

https://authentification.site/files/21978173/ExampleDoc.xlsx

Thanks again,

steve

Just to add, the worksheet named "sheet1" is how it is originally, and i want to distribute data to the three other worksheets as shown :)

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Apr 17, 2010 at 06:08 AM

Apr 17, 2010 at 06:08 AM

Steve, what is the concept of day. The most efficient way is to move all the data including day. You said that the data needs to go to the row with matching day. Is this just day of month and would be going from 1-31, one row at a time ? In that case the missing dates can be added once the data has been moved. Or is there a problem

Didn't find the answer you are looking for?

Ask a question
Hi rizvisa,

I was looking around and someone suggested the following formula, which works:)

'SUPPORT' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!C2,"")

'PACKAGE' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!C2,"")

'GENERAL' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="GENERAL",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="GENERAL",Sheet1!C2,"")

However, the remaining question that noone seems to be able to answer is as follows. How would I have to adjust the formula if I wanted more than one "text" transferred into one worksheet. For example, if I wanted the information regarding "PACKAGE" and "SUPPORT" to go into the worksheet named PACKAGE.

If you could give me a solution, I shall be eternally grateful :D

Steve

I was looking around and someone suggested the following formula, which works:)

'SUPPORT' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!C2,"")

'PACKAGE' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!C2,"")

'GENERAL' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="GENERAL",Sheet1!B2,"")

Cell C2: =IF(LEFT(Sheet1!B2,7)="GENERAL",Sheet1!C2,"")

However, the remaining question that noone seems to be able to answer is as follows. How would I have to adjust the formula if I wanted more than one "text" transferred into one worksheet. For example, if I wanted the information regarding "PACKAGE" and "SUPPORT" to go into the worksheet named PACKAGE.

If you could give me a solution, I shall be eternally grateful :D

Steve

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Apr 19, 2010 at 04:53 AM

Apr 19, 2010 at 04:53 AM

'PACKAGE' Worksheet:

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!B2,IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!B2,""))

Cell C2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!C2,IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!C2,""))

How ever, I am not too sure if using the formula is the way to go. It can cause grief, during filtration, deleting or moving around rows. Since you know your requirement best, you would know if that is some thing you should be concerned about or not

Cell A2: =Sheet1!A2

Cell B2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!B2,IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!B2,""))

Cell C2: =IF(LEFT(Sheet1!B2,7)="PACKAGE",Sheet1!C2,IF(LEFT(Sheet1!B2,7)="SUPPORT",Sheet1!C2,""))

How ever, I am not too sure if using the formula is the way to go. It can cause grief, during filtration, deleting or moving around rows. Since you know your requirement best, you would know if that is some thing you should be concerned about or not