I
Icehockey44
Hello,
i have a database, which I am trying to extract data out of and pop ont
monthly sheets.
Baiscally it for a visit schedule over a 12 month period from ownership
So we will have 6 visits a year, each visit has different tasks to b
carried out.
So I need all the jobs that require a visit in Aug-13 regardless of wha
number visit it will be, populated into the Aug-13 tab, and so on.
when I do this, the formula that I am using leaves blank rows unti
Aug-13 appears in a certain cell. This is no good due to the top of th
spreadsheet being empty, will data population further down, results i
the engineer missing these visits.
the formula that I have been using is as follows:
IF('Master'!$I4="Aug-13",'Master'!A8,"")
I have attached an example for what i would like the report to loo
like.
If you have any suggestions on how I would get this sorted, they woul
be very much appreciated.
i would prefer Excel formula's, but marcos or VBA would also be a
option, although I am not too up to gether on the later 2, and th
person using the spreadsheet is a beginner excel user.
I look forward to all of your suggestion
Donn
+-------------------------------------------------------------------
|Filename: Database Data Division less blanks 1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=913
+-------------------------------------------------------------------
i have a database, which I am trying to extract data out of and pop ont
monthly sheets.
Baiscally it for a visit schedule over a 12 month period from ownership
So we will have 6 visits a year, each visit has different tasks to b
carried out.
So I need all the jobs that require a visit in Aug-13 regardless of wha
number visit it will be, populated into the Aug-13 tab, and so on.
when I do this, the formula that I am using leaves blank rows unti
Aug-13 appears in a certain cell. This is no good due to the top of th
spreadsheet being empty, will data population further down, results i
the engineer missing these visits.
the formula that I have been using is as follows:
IF('Master'!$I4="Aug-13",'Master'!A8,"")
I have attached an example for what i would like the report to loo
like.
If you have any suggestions on how I would get this sorted, they woul
be very much appreciated.
i would prefer Excel formula's, but marcos or VBA would also be a
option, although I am not too up to gether on the later 2, and th
person using the spreadsheet is a beginner excel user.
I look forward to all of your suggestion
Donn
+-------------------------------------------------------------------
|Filename: Database Data Division less blanks 1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=913
+-------------------------------------------------------------------