Copy some of selected columns to master sheet

[sanju]

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]

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

=Peter!A

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

Other than that you need to be a little clearer


H

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 fro
the updated of individual sheets

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

Regard
Sanjay


--
Simon Lloyd

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

 

[sanju]

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/showthread.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)

 

[Simon Lloyd]

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


On Apr 11, 12:46*pm, Simon Lloyd <[email protected]
wrote

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

this assuming the worksheet is called Peter and you want the valu fro

Other than that you need to be a little clearer

sanju;691558 Wrote

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 fro
the updated of individual sheets

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

-
Simon Lloy

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

Code Cage Forums
(http://www.thecodecage.com/forumz/showthread.php?t=193336

'Microsoft Office Help - Microsoft Office Discussion - Excel VB

Programming - Access Programming' (http://www.thecodecage.com/forumz

Thanks Simon, although both sheets are in the same format, but thes
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 pete
(rowx,column10) to master(rowx, column10)


--
Simon Lloyd

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