transposing info.

  • Thread starter Thread starter guideme
  • Start date Start date
G

guideme

I want to transfer information from one spreadsheet to another with
different titles on the columns. How do I do this?

I want to direct the values on the column which has a different title
column to the sheet that I want to move it to.

Thanks
 
guideme said:
I want to transfer information from one spreadsheet to another with
different titles on the columns. How do I do this?

I want to direct the values on the column which has a different title
column to the sheet that I want to move it to.

Thanks
Click to expand...

This is more of moving data to another sheet which has different column
titles.
 
Try selecting the first line and then press
CTRL+SHIFT + DOWN

this is suppose to select all the (used) rows in the column, then you
can CTRL+C (copy) that to the first cell (under the new titles) (CTRL+V
past)

if your data in columns can contain empty rows, it's a bit more
difficult i guess, but forst of all: is this enought to help you ? try
it first
 
well... the first column on sheet 2 does not necessarily go on sheet 1
column 1.
It could go from sheet 1, column 5 to sheet 2 (say) column 2.

also, the column headers have dropdown menus.
 
well, ok, but what you are saying is that you need to copy columns one
at a time to put it on the right place. I was saying you can copy the
column without the title.

(using a macro or a manual making is the same: you can copy a column
without the title)

And i suppose this is what you need to know for going on...
just try
 
Hi, thanks anyway.
I can't keep copying the same spreadsheet everyday... I need a macro to
do this.
 
Hi Guideme,
Hi, thanks anyway.
I can't keep copying the same spreadsheet everyday... I need a macro to
do this.
Click to expand...

In that case, you need to provide potential helper with sufficent,
intelligible information to assist you.

The first paragraph of your initial post read:
I want to transfer information from one spreadsheet to another with
different titles on the columns. How do I do this?
Click to expand...

This represents too little information ...

The second paragraph of that post read:
I want to direct the values on the column which has a different title
column to the sheet that I want to move it to.
Click to expand...

Frankly, endeavouring to unravel the significance of thiis is quite beyond
me.

You provided the following information in a follow-up post:
I want to transfer information from one spreadsheet to another with
different titles on the columns. How do I do this?

I want to direct the values on the column which has a different title
column to the sheet that I want to move it to
Click to expand...

In order to gain any useful assistance, I think you will need to provide
some explantion for what, on the basis of current information, appear to be
arbitrary, indeterminate data movements.

There are many who would willingly assist you, but you mut enunciate your
requirements in such a fashion as to enable them so to do.
 
its easy.. what you do is this:

a) keep your data in a db instead of in excel
b) render your data however you want using the most powerful reporting
platform in the world-- Microsoft Access
 
Back
Top