Previous Topic Next Topic

Conditional formatting.

Closed
hmnanavati Posts 1 Registration date Tuesday August 2, 2016 Status Member Last seen August 2, 2016 - Aug 2, 2016 at 07:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2016 at 10:36 AM
Hi, I have prepared a master sheet in which we enter the data. There are different sheet in the same file which will use the same data but not simultaneously and not in same order as that of master sheet. So how do i activate a particular sheet so that data so entered in Master sheet is transferred to a particular sheet which i want at a time. As i do not want the same to be filled in all sheets simultaneously. Conditional activation?. Please guide.

3 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 4, 2016 at 10:53 AM
Hi Hmnanavati,

So you want some data entered in the master sheet also be entered in another sheet.

Can you give some examples of how your sheets looks like and also what the criteria is for copying data to which sheet?

Best regards,
Trowa
0
Answer 2 / 3
hmnanavati
Aug 5, 2016 at 02:12 AM
Could you please share your email id. so that we can send the excel sheet.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 9, 2016 at 10:36 AM
Hmnanavati,

To share your Excel file, you can use a free filesharing site like www.speedyshare.com or ge.tt. Don't forget to post back the download link and Always be careful with sensitive data.

Also make sure it is clear which data needs to go where and when.

Best regards,
Trowa
0
Answer 3 / 3
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 1
Aug 6, 2016 at 07:41 PM
Your request is a bit unclear, and Im not sure you fully understand the way excel works.

If you want different data on different sheets, then extract it that way to each sheet. Depending on how your data looks and how you want the extract, you could use a direct reference (=A1), or something a bit more complex like vlookup() or INDEX/MATCH
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses