LinkBack URL
About LinkBacks
I would like to create a work order on one sheet and pull the data to a spreadsheet. I do not know which functions. I have tried the pivot table and that is not working for me. Any suggesteds please????
What function to use for pulling data
I would like to create a work order on one sheet and pull the data to a spreadsheet. I do not know which functions. I have tried the pivot table and that is not working for me. Any suggesteds please????
You will need to post a sample workbook showing what you are inputting and what you are expecting on the the other sheet.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Work order spreadsheet.xlsx
Hopefully this will open for you. Thank you so much
Are you going to have multiple work orders that you'd like to pull from and place their data on a single sheet?
Will each work order be in the same workbook or on separate worksheets?
I was planning to enter the work order but I was not going to save it once it it printed. So each work order I enter would like the data to be recorded on the spreadsheet and then reuse the same work order again and again.
NBVC
Just wondering if it opened for you and if you had any questions.
It looks like it will involve VBA if you want to keep adding lines and then overwrite work order and not deleting the lines in second sheet...
Unfortunately, VBA is not currently in my scope here... so will have to rely on VBA experts' input.
Is there a VBA Expert out ther to help me out?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks