Active Worksheet data transfer

[tommclernon]

I am not a VBA coder, and have looked at a lot of different potential solutions, but apparently there is no Boolean code solution.

I have a workbook with many identical worksheets (the data in each may be different, but the layout is identical) what VBA coding would take data from a cell (of the same address) in any "active" sheet of these identical worksheets, and place it in a cell range (column) in another worksheet of the workbook. (populate from whatever worksheet is open only)

I had thought this kind of function would be fairly common, but have not been able to find any VBA code that has a remotely similar function.

Any help will be appreciated.

Thanks

 

[mumps]

Do you want to copy a cell from the active sheet to the same cell in another sheet? If so, how do you decode which cell and which sheet will be the destination sheet?

 

[tommclernon]

Do you want to copy a cell from the active sheet to the same cell in another sheet? If so, how do you decode which cell and which sheet will be the destination sheet?

The data is in a single cell in the source, which is one of many possible active sheets. (same address in all source sheets)

This single cell data (from many possible when active sheets) needs to be exported to many cells (down a column) in a single receiving sheet. And replace the data that was there from the export of the previous activesheet.

Basically the sheet that the data is being exported to, does a combine data function that enables a VLOOKUP to pull data against the many changing combined values.

Thanks,
Tom McLernon

 

[mumps]

What is the address of the single cell you want to copy? What is the name of the receiving sheet and in which column and cells do you want to paste the single cell? It would be easier to help if you could post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.