Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Desperately in need of some help
I am trying to automate what has been a manual process. The assumption
was that the app that we get the data from could not export to something that excel or access could use. The app can output the data and so I would like to use excel to do a couple of things. This is for excel 2003. First, I need to highlight a row based on the value in one cell. I have tried the conditional formatting but all I get is the A column cell with the highlight even if I have selected A5:H5 I have tried to test for the value in a cell or the result of a formula with the same results. The second thing I would like to do is copy values to a second sheet within the same workbook. The second worksheet would detail absence for a year and would look at 3 types of leave. I understand that I would have to somehow test that the date in column 1 of sheet 1 is (greater than or equal to Jan 1and less than or equal to Dec 31) AND (hat the value in column F="Cert"). I get that I would have to repeat that for the years that are desired and for the different types of absence. What I don't get is how to do it. Is this even possible in Excel? Do I need to use Access instead? I am reasonable computer savvy but not great on Excel. Appreciate any help I can get! Thank you. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Desperately in need of some help
Conditional formatting:
Assume value to trigger format is in column A In A1 to enter your Conditional Format - change to 'Formula is' =$A1=whatever your value is And the format you require. Test with your value in A1. If OK, copy across columns (using a single row) as far as you require. Now copy that row down as far as you require. Now when you enter 'your value' in column A, the complete row will reflect your format. Your second problem requires more clarification to identify a solution. "perfj" wrote: I am trying to automate what has been a manual process. The assumption was that the app that we get the data from could not export to something that excel or access could use. The app can output the data and so I would like to use excel to do a couple of things. This is for excel 2003. First, I need to highlight a row based on the value in one cell. I have tried the conditional formatting but all I get is the A column cell with the highlight even if I have selected A5:H5 I have tried to test for the value in a cell or the result of a formula with the same results. The second thing I would like to do is copy values to a second sheet within the same workbook. The second worksheet would detail absence for a year and would look at 3 types of leave. I understand that I would have to somehow test that the date in column 1 of sheet 1 is (greater than or equal to Jan 1and less than or equal to Dec 31) AND (hat the value in column F="Cert"). I get that I would have to repeat that for the years that are desired and for the different types of absence. What I don't get is how to do it. Is this even possible in Excel? Do I need to use Access instead? I am reasonable computer savvy but not great on Excel. Appreciate any help I can get! Thank you. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Desperately in need of some help
On Apr 2, 3:39*am, Ron@Buy wrote:
Conditional formatting: Assume value to trigger format is in column A In A1 to enter your Conditional Format - change to 'Formula is' =$A1=whatever your value is And the format you require. Test with your value in A1. If OK, copy across columns (using a single row) as far as you require. Now copy that row down as far as you require. Now when you enter 'your value' in column A, the complete row will reflect your format. Your second problem requires more clarification to identify a solution. "perfj" wrote: I am trying to automate what has been a manual process. The assumption was that the app that we get the data from could not export to something that excel or access could use. The app can output the data and so I would like to use excel to do a couple of things. This is for excel 2003. First, I need to highlight a row based on the value in one cell. I have tried the conditional formatting but all I get is the A column cell with the highlight even if I have selected A5:H5 I have tried to test for the value in a cell or the result of a formula with the same results. The second thing I would like to do is copy values to a second sheet within the same workbook. The second worksheet would detail absence for a year and would look at 3 types ofleave. I understand that I would have to somehow test that the date in column 1 of sheet 1 is (greater than or equal to Jan 1and less than or equal to Dec 31) AND (hat the value in column F="Cert"). I get that I would have to repeat that for the years that are desired and for the different types of absence. What I don't get is how to do it. Is this even possible in Excel? Do I need to use Access instead? I am reasonable computer savvy but not great on Excel. Appreciate any help I can get! Thank you.- Hide quoted text - - Show quoted text - Ron, I apologize for the delay in getting back to you. I was yanked quite suddenly away from town. I should be able to try your suggestion in a couple of days. As for the second part, I think that the organization may be acquiring new software to do leave analytics, which I enthusiastically support. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Desperately need a command or something! | Excel Discussion (Misc queries) | |||
DESPERATELY NEED HELP | Excel Discussion (Misc queries) | |||
Desperately need help!! | New Users to Excel | |||
Desperately need help with 3 calculations | Excel Worksheet Functions | |||
Desperately need help!!! Pivot table | Excel Discussion (Misc queries) |