Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to write some code to look for missing data. Each month a facility is
supposed to enter data for that month. I have to download a file which has this monthly data for several facilities compiled into one file. What I need the code to do is look at the date in a cell (B5) and then search the document for the hours associated with that month. If a facility did not enter their data, then I need the code to copy the previous month's hours into the current months hours. For example: B5 = Apr 07 A B C D 9 Jan Feb Mar Apr 10 200 299 104 0 11 400 400 333 233 12 200 300 900 100 13 233 444 555 0 I want to code to change the "0" in column D at row 10 to "104" and D13 from "0" to "555". Thanks. Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
connect line to data points with missing data in between | Charts and Charting in Excel | |||
Missing Cloumn data when importing external data | Excel Discussion (Misc queries) | |||
How to determine the cause of missing data after I importing data | Excel Discussion (Misc queries) | |||
How do i plot a data set that has one data point missing | Excel Discussion (Misc queries) | |||
Import External Data is missing some data | Excel Discussion (Misc queries) |