Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Pulling Data from another sheet
I have data in a worksheet that pulls to another, but I was wondering can I
set it up so that it only pulls data from the last month that I entered as it goes on or do I have to make a new worksheet for each month of the data in the workbook so that it only pulls the newest month of data that I entered. Or should I use access for this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Pulling Data from another sheet
It can be done, depending on how your data sheet is set up. We'll need more
details if you want specific help... -- JNW "Anthony" wrote: I have data in a worksheet that pulls to another, but I was wondering can I set it up so that it only pulls data from the last month that I entered as it goes on or do I have to make a new worksheet for each month of the data in the workbook so that it only pulls the newest month of data that I entered. Or should I use access for this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Pulling Data from another sheet
Ok, what details do you need?
"JNW" wrote: It can be done, depending on how your data sheet is set up. We'll need more details if you want specific help... -- JNW "Anthony" wrote: I have data in a worksheet that pulls to another, but I was wondering can I set it up so that it only pulls data from the last month that I entered as it goes on or do I have to make a new worksheet for each month of the data in the workbook so that it only pulls the newest month of data that I entered. Or should I use access for this. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Pulling Data from another sheet
well... for starters, is there a date in every row of data? what information
are you pulling? how do you want to select the month on the summary sheet? Not every detail is needed but enough to be able to get you a answer you can work with. -- JNW "Anthony" wrote: Ok, what details do you need? "JNW" wrote: It can be done, depending on how your data sheet is set up. We'll need more details if you want specific help... -- JNW "Anthony" wrote: I have data in a worksheet that pulls to another, but I was wondering can I set it up so that it only pulls data from the last month that I entered as it goes on or do I have to make a new worksheet for each month of the data in the workbook so that it only pulls the newest month of data that I entered. Or should I use access for this. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Pulling Data from another sheet
It would be by the month on the top of each data sheet.
"JNW" wrote: well... for starters, is there a date in every row of data? what information are you pulling? how do you want to select the month on the summary sheet? Not every detail is needed but enough to be able to get you a answer you can work with. -- JNW "Anthony" wrote: Ok, what details do you need? "JNW" wrote: It can be done, depending on how your data sheet is set up. We'll need more details if you want specific help... -- JNW "Anthony" wrote: I have data in a worksheet that pulls to another, but I was wondering can I set it up so that it only pulls data from the last month that I entered as it goes on or do I have to make a new worksheet for each month of the data in the workbook so that it only pulls the newest month of data that I entered. Or should I use access for this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Data from another sheet | Excel Discussion (Misc queries) | |||
pulling data from one sheet to another | New Users to Excel | |||
pulling data from another sheet | Excel Discussion (Misc queries) | |||
Newbie question Pulling data from one sheet to another based on | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |