Creating Daily Report from Monthly spreadsheet

[levanduski00]

This is my situation-

I have a workbook with several revenue type sheets. Each sheet has data entered by day (columns) for a period of a month. I want to create an additional sheet which will allow me to pull data for a specific day to create a daily report (for the day specified).

Any help would be creatly appreciated, and if it helps, I can provide the file in which I'm working on.

Thanks,
Roger

 

[PaddyD]

Hi - welcome to the board!

In general, if you have a column of data (eg your dates) & want to return data from a column to its right based on the value in the (e.g.) dates column, the function to use is vlookup(). check it out in the help file & search here for examples.

Post back with more info about how your data is set up & what result you are trying to achieve...

Paddy

 

[Derek]

Hi Roger

Have you looked at using the VLOOKUP formula?
Put the required date in A1 of your new sheet and have your Vlookup formula reference this to find the required entries in the date column of your monthly sheet. This way you can change the date in A1 to whatever you want.

If you need more help, post the column heading in your month sheet and the name of the two sheets.

regards
Derek

 

[DonkeyOte]

If your dates are in the colums - name the whole sheet that contains the month data (e.g.sheet1), in the box to the top left of A1) Data - and then use HLOOKUP (H = horizontal - so it looks in the colum headings until it finds a match, VLOOKUP being vertical, ie it looks in rows until it finds a match) on the data.

So say A1 on your report sheet = required date for report

and A2 = Revenue Type

A2 = hlookup(a1,sheet1!DATA,1,FALSE)

where 1 equals the row number - which would be your first revenue type)