ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   paste if columns and rows are the same (https://www.excelbanter.com/excel-programming/445891-paste-if-columns-rows-same.html)

MIMICI

paste if columns and rows are the same
 
Hi, I'm not yet so familiar and at ease with excel programming, though I use Excel since a very long time. Now I need to go to more complicated tools.

This question might then seem very easy to some of you, which would help me a lot.

I have several data bases for networks relations, basically always the same sheets with the same columns header and row names but for different locations and time.

I want to group them in one document and so copy data from one sheet to the new one where values must be paste where the colomn header and the row name are the same than in the original sheet.
Is this possible?

I have to do that for 8 sheets which will have the same names in the orignial separate 3 documents and in the new one.

Thank you very much for your help

Paul Robinson

paste if columns and rows are the same
 
Hi
You question is too vague and I do not think anyone will reply.
Remember, we cannot see what you can see and cannot picture what you
want. You must show people exactly what you have and then exactly what
you want.
regards
Paul

On Apr 26, 11:26*am, MIMICI wrote:
Hi, I'm not yet so familiar and at ease with excel programming, though I
use Excel since a very long time. Now I need to go to more complicated
tools.

This question might then seem very easy to some of you, which would help
me a lot.

I have several data bases for networks relations, basically always the
same sheets with the same columns header and row names but for different
locations and time.

I want to group them in one document and so copy data from one sheet to
the new one where values must be paste where the colomn header and the
row name are the same than in the original sheet.
Is this possible?

I have to do that for 8 sheets which will have the same names in the
orignial separate 3 documents and in the new one.

Thank you very much for your help

--
MIMICI



Don Guillett[_2_]

paste if columns and rows are the same
 
On Thursday, April 26, 2012 5:26:47 AM UTC-5, MIMICI wrote:
Hi, I'm not yet so familiar and at ease with excel programming, though I
use Excel since a very long time. Now I need to go to more complicated
tools.

This question might then seem very easy to some of you, which would help
me a lot.

I have several data bases for networks relations, basically always the
same sheets with the same columns header and row names but for different
locations and time.

I want to group them in one document and so copy data from one sheet to
the new one where values must be paste where the colomn header and the
row name are the same than in the original sheet.
Is this possible?

I have to do that for 8 sheets which will have the same names in the
orignial separate 3 documents and in the new one.

Thank you very much for your help




--
MIMICI


More info needed as to layout etc
or send file(s) to


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com