Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,522
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i paste rows/columns avoiding hidden rows/columns perezli Excel Discussion (Misc queries) 1 January 30th 09 03:58 PM
Transposing Rows and Columns Using Paste Special TLW Excel Discussion (Misc queries) 1 October 11th 07 04:41 PM
copy columns paste in rows ezil Excel Programming 4 August 12th 07 04:24 PM
How can I CUT and paste to convert columns to rows? Lillylutoo Excel Worksheet Functions 5 June 15th 06 08:21 PM
How do I cut & paste non-adjacent rows or columns ONLY in auto-fil Amadoda Excel Worksheet Functions 1 January 11th 05 01:01 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"