conditional copy of data

Hi, I want to default value of a cell into multiple cells based on a condition For example : If cell C10 = "Yes", then put value of cell F10 in multiple cells like C42, I42, G42. If cell C10 = "No", then the user can enter their own values in C42, I42, G42 etc. I cannot put conditional...

I have a list that consists of names of files in a folder. In the table there are 2 other columns that have "Yes" and "No" conditions. Lets assume I have ABC_00 file in A2 and conditions are in B and C columns. Then B2 is "Yes" and C2 is "No" lets say. I need a VBA code that even one of the...

Hello, I am slowly building my knowledge up by trial and error and tons of money on books. However, I cannot seem to figure this out. I have a workbook with 4 sheets, Home, Team 1, Team 2, and Team 3. On the Sheet "Home" I have a simple 4 cell system. "C9" is a drop down box with 18...

Hi, I am trying to create a work book containing names of people with the color coded dates if that certain item is near expiry or is already expired. I have done that conditional formatting, however the data is too many for me to narrow down as to what has expired. Question: I created a new...

Is it possible to present different list on spreadsheet that is dependent on a value of cell on another sheet? It sounds simple but I can't seem to find out how. I have a 4 list that I want to show up conditionally on a spread sheet. I could try hiding rows but I thought Excel 2010 would have a...

I have a multi-tab spreadsheet and want to auto-populate data from one sheet to another sheet based on IF a value exists on first sheet. On my first tab, 'Bill of Materials Pricing', IF Qty Exists in column "I", THEN would like to write the values from columns A, B and I from that particular...

Hello friends i am new to excel and vba and i don't use it often. I am stuck in a problem i don't know where to find it, google returns results but it is beyond my understanding. my workbook has 2 sheets and i want to create a summary of it Sheet 1 has a student list which contain 2 fields...