Copy some of selected columns to master sheet
 

Hi

I have a master sheet of all users say Chris, TOM, Peter etc .
(identified in Column D of master sheet).
Each of these also give me their individual reports.
How can I update some of the selected columns of my master sheet from
the updated of individual sheets.

Formats (column, row etc.) of both master and individual sheet is
same.
I just need that whaterver daily updates in some of the columns I get
from individual should get reflected in my master sheet.
Your urgent help is highly appreciated.

Regards
Sanjay

Copy some of selected columns to master sheet
 

Couldn't you simply use a formula in your master sheet like this:

=Peter!A1

this assuming the worksheet is called Peter and you want the value from
A1.

Other than that you need to be a little clearer.


sanju;691558 Wrote:

Hi

I have a master sheet of all users say Chris, TOM, Peter etc .
(identified in Column D of master sheet).
Each of these also give me their individual reports.
How can I update some of the selected columns of my master sheet from
the updated of individual sheets.

Formats (column, row etc.) of both master and individual sheet is
same.
I just need that whaterver daily updates in some of the columns I get
from individual should get reflected in my master sheet.
Your urgent help is highly appreciated.

Regards
Sanjay


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193336

http://www.thecodecage.com/forumz

Copy some of selected columns to master sheet
 

On Apr 11, 12:46*pm, Simon Lloyd
wrote:
Couldn't you simply use a formula in your master sheet like this:

=Peter!A1

this assuming the worksheet is called Peter and you want the value from
A1.

Other than that you need to be a little clearer.

sanju;691558 Wrote:

Hi

I have a master sheet of all users say Chris, TOM, Peter etc .
(identified inColumnD of master sheet).
Each of these also give me their individual reports.
How can I update some of the selected columns of my master sheet from
the updated of individual sheets.

Formats (column, row etc.) of both master and individual sheet is
same.
I just need that whaterver daily updates in some of the columns I get
from individual should get reflected in my master sheet.
Your urgent help is highly appreciated.

Regards
Sanjay

--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=193336

http://www.thecodecage.com/forumz

Thanks Simon, although both sheets are in the same format, but these
may not be in the same row in individual report and master report.

Say, all these are correlated though entries in column1.
If Peter(row10, column1)= master(row25, colum1) then copy peter
(rowx,column10) to master(rowx, column10)

Copy some of selected columns to master sheet
 

For further help with it why not join our forums (shown in the link
below). It's completely free. If you do join you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)


sanju;698639 Wrote:

On Apr 11, 12:46*pm, Simon Lloyd
wrote:
Couldn't you simply use a formula in your master sheet like this:

=Peter!A1

this assuming the worksheet is called Peter and you want the value
from
A1.

Other than that you need to be a little clearer.

sanju;691558 Wrote:

Hi

I have a master sheet of all users say Chris, TOM, Peter etc .
(identified inColumnD of master sheet).
Each of these also give me their individual reports.
How can I update some of the selected columns of my master sheet from
the updated of individual sheets.

Formats (column, row etc.) of both master and individual sheet is
same.
I just need that whaterver daily updates in some of the columns I get
from individual should get reflected in my master sheet.
Your urgent help is highly appreciated.

Regards
Sanjay

--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)

------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread:'Copy some of selected columns to master sheet - The
Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=193336)

'Microsoft Office Help - Microsoft Office Discussion - Excel VBA
Programming - Access Programming' (http://www.thecodecage.com/forumz)

Thanks Simon, although both sheets are in the same format, but these
may not be in the same row in individual report and master report.

Say, all these are correlated though entries in column1.
If Peter(row10, column1)= master(row25, colum1) then copy peter
(rowx,column10) to master(rowx, column10)


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193336

http://www.thecodecage.com/forumz