[mark.elgueta]

hi guys! i need some help with an excel file.

is there some type of macro that i can use here? i'll attach the file.

i have a summary sheet that i would like to have populated with information from the "POtemp_NY" sheet. On the summary sheet, i have the column headers listed for the info that i need to be taken from the "POtemp sheet_NY". Can i have the file set up so that after i print or save the "POtemp_NY" sheet, the summary sheet will populate with the information needed, clear out the info on the "POtemp_NY" sheet and then move on to the next line in the "summary" sheet to be automatically populated as well?

it's the same file that i was working on before but i had a different idea as to what can be done to work through excel and not have to use access.

[mark.elgueta]

hey guys any help with this?

[OBP]

mark, why don't you want to use Access, it is much better for this kind of application?
If you need help with Access I will galdly provide it.

But back to your question, I can't relate the Headings in the Summary sheet to the data in the "POtemp_NY" sheet, what goes where?

If you know any VBA then this thread has a similar question with a very good response from Jimmy the Hand.
http://forums.techguy.org/business-a...rksheet-2.html

[mark.elgueta]

obp,

i do def, agree that access would be more efficient but this task requires that i use excel. the people here are pretty slow and we also don't have access on our computers. go figure. anyway...if you could be of any help that would be great! if not, just let me know so i can mark this as solved. thanks!

[OBP]

Did you look at the VBA that Jimmy posted?
Do you need help with that?
Can you answer the question about what goes wgere on the Summary?
Some dummy data would be nice!

[mark.elgueta]

obp,

Thanks for your help. I checked out the VBA but i think to get the functionality that they want, i will need Access. I changed the setup of my file now so the function of keeping record of created PO's in the summary sheet is no longer needed. I'm just going to have to get these guys to install access. when that happens, i'll probably repost. Besides that, i think i am fine. I will attach a copy of what my file looks like now.

they ultimately wanted a form sheet where questions would be answered and those answers would populate the POtemp sheet.

Without the record keeping function i have a handle of the excel file. Thanks again for your help!