Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Transposing Rows and Columns Using Paste Special | Excel Discussion (Misc queries) | |||
copy columns paste in rows | Excel Programming | |||
How can I CUT and paste to convert columns to rows? | Excel Worksheet Functions | |||
How do I cut & paste non-adjacent rows or columns ONLY in auto-fil | Excel Worksheet Functions |