Excel 2007 : Populating Data from one sheet to another sheet automatically

**Shameerah** · 04-13-2012, 05:10 AM

Hi,

Need on your help for populating data automatically from one sheet to another sheet based on selected data. Specifications are as follows:
* I input a row of data on Sheet A and from the same row, in Column D, I have a drop down with selections (WIP,Won,Loss). When I select "Won", certain details of the data row with the "Win Selection" is populated automatically in Sheet B.

Attach is a testing data spreadsheet.

Thanks

**arlu1201** · 04-13-2012, 05:27 AM

Try this code. Right click on Sheet A and input this

Please Login or Register  to view this content.

**royUK** · 04-13-2012, 06:57 AM

I really can't see the need for moving data. If you change the Status column then it's simpler to keep all the data one sheet & use AutoFilter to check details.

If you really want to do this have 3 sheets -Won,WIP & Lost. Add this code to the worksheet module

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

**Shameerah** · 04-14-2012, 12:58 PM

Hi guys,

The codes are not wroking. Infact, it is changing the status of the next row within Sheet A itself.

My objectove is that I want data in Sheet A to be automatically populated in the other sheet (Sheet B) whenever I change the status in Column D in Sheet A. For example, if I change the status of a project from "WIP" to "Won", I want the fields (Project, Country & Sector) to be populated in Sheet B automatically.

Thanks for helping. I am really stuck with it.

**royUK** · 04-14-2012, 01:09 PM

My code moves the data to the relevant sheet, as I said to make it simpler use the sheet names to correspond with the status. Have you tried it?

**Shameerah** · 04-14-2012, 01:16 PM

I can't really use the status description as the Sheet Names since actually I have three sheets named as follows:
*Opportunities
*Invoice
*Projects

The Opportunities Sheet is the master data. All entries are done manually in this sheet. When the status of the a row changes from WIP to Won, it is then the data should be filled in automatically in Invoice and Projects Sheets.

Thanks

**royUK** · 04-14-2012, 02:37 PM

Then adapt the code that I posted. Your explanation doesn't match the example - you have 3 statuses in the example - Won, WIP & Lost. If you can't adapt the code then post a better example