overlap data from one spreadsheet to other

[luis6777]

Good afternoon
I’m trying to create a spread sheet that will allow me to enter data in cells but replace that date with data from a different spread sheet if a specific data is entered in that second spread sheet.

Someone help with this would be much apreciated

Thanks

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[luis6777]

i have try to replicate what i would like to do in one sheet, basicaly it demonstrate that i will have 2 spread sheets and i will insert data in the second spread sheet but when in the 1st spread sheet i will have a specific data (10 in this example) it will copy to the second spread sheet.

[alansidman]

Ok, you have uploaded the file with an example. Now, what will determine that a particular cell is transferred to the second sheet? What determines the cell to be copied? What determines the target cell? This is important to understand your issue and how to give you a valid solution. Help us to help you.

[luis6777]

Ok, you have uploaded the file with an example. Now, what will determine that a particular cell is transferred to the second sheet? What determines the cell to be copied? What determines the target cell? This is important to understand your issue and how to give you a valid solution. Help us to help you.

Hi

Please see below the answers to your questions, hope that helps

what will determine that a particular cell is transferred to the second sheet? This will be determinated by the value, in this example is 10, so if in the 1st spread sheet we have value 10 in a cell that value will be transfered to the same cell in the spread sheet 2 overlaping the value corrently there

What determines the cell to be copied? The value on the cell in this example will be 10

What determines the target cell? It will be the equivalent cell on the second sheet

[alansidman]

The only way I know of doing this is to use VBA

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[luis6777]

The only way I know of doing this is to use VBA

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Thank you for the above, the spread sheet that i have previously attached was a example, i actually need to work with 2 diferent spreadsheets how can i do that using the above

Thanks

[alansidman]

When you say two different spreadsheets, are you talking two different workbooks? If so, what are the names and will they both be open? Or are you working with two different sheets in the same workbook. If that is the case, what are the names of the sheets?

It seems that you have changed your requirements from the initial post. Why did you not give us all the details to start with instead of having us redo our work. That is not very efficient for either you or me. Please keep that in mind in the future.

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.