Transfer Required Data to a Different Worksheet Dependant on Cell Value

**DGTech** · 08-17-2012, 06:30 AM

Hi,

Firstly I apologise in advance for my lack of experience with not only Excel but also this forum.

Right... I am currently working on a synthetic bill of materials for a new project and I need to take certain data from each of the different worksheets and input it into a different sheet.

- Basically when a part is going to be new to the machine it will be given a "X" in a cell.
- When this "X" is seen I need it to take the part number and description (with are inputted in the cells to the left of the "X”) and add them to another worksheet.
- For each time it sees a "X" it needs to do this so that the end result is that all new parts can be seen in one comprehensive list.

I was planning on the macro running through an update tracker button.

The problem is I do not have a clue how to do this or if in fact it even can be done.

Could somebody help me with this issue?

Many Thanks

**arlu1201** · 08-17-2012, 06:58 AM

Sure, this can be done.

Do you have a sample file that you can upload? I can provide you the code for it.

Also, will the destination sheet already exist in the file with headers? Or should it be created by the macro?

---------- Post added at 04:28 PM ---------- Previous post was at 04:27 PM ----------

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**DGTech** · 08-17-2012, 07:44 AM

Thanks you for your quick response.

I have created a quick example file which shows exactly what I mean to help you as much as possible.

Many Thanks
Darren

**arlu1201** · 08-17-2012, 07:52 AM

Wow, thats a very nice requirements tab.

So you will be updating the column K in both sheets and then click the Update sheet button for the data to be transferred right?

What if you have clicked the button and the data has transferred. Then you realise you missed a few more entries that had to be marked "X", so you press the button again. When you press the button again, do you want the macro to clear the destination sheet and re-update with fresh data? If not, there are chances of duplicate data pouring in.