Here is my question:
Workbooks: Daily, Unit A, Unit B, Unit C, Unit D
Unit A, Unit B.... workbooks are a monthly log of information collected daily.
what i am looking to do is daily i fill out a workbook (Daily) with all information for each unit (Unit A, Unit B...) everyday. I am trying to figure out how to populate Unit A, Unit B... workbooks with the daily information gathered.
For instance Daily cell A1 = the date March 1st. Daily line 2 = all information for Unit A for March 1st.
Unit A cell A1 = March 1st. I am looking to copy line 2 from Daily to line 1 Unit A on a save command possibly. Then on march 2nd it would move to Unit A line 2.... and so on.
Probably jumbled but hopefully it makes sense to someone smater than I...
Workbooks: Daily, Unit A, Unit B, Unit C, Unit D
Unit A, Unit B.... workbooks are a monthly log of information collected daily.
what i am looking to do is daily i fill out a workbook (Daily) with all information for each unit (Unit A, Unit B...) everyday. I am trying to figure out how to populate Unit A, Unit B... workbooks with the daily information gathered.
For instance Daily cell A1 = the date March 1st. Daily line 2 = all information for Unit A for March 1st.
Unit A cell A1 = March 1st. I am looking to copy line 2 from Daily to line 1 Unit A on a save command possibly. Then on march 2nd it would move to Unit A line 2.... and so on.
Probably jumbled but hopefully it makes sense to someone smater than I...
