Since Excel 2008 cannot run VBA macros, so we are confined to using formulas. If you could send me the file I will take a look at it and let you know.
Ok, go to www.wikisend.com and upload the file there. You will then get a page that has the File ID and Download Link. Copy either the File ID or the Download Link and come back here and paste it in your reply.
If the file has sensitive information you can either replace the sensitive data with dummy values, or let me know before you upload it.
Got it, thanks.
There seem to be some inconsistencies between the sheet names as they appear ion the sheets tabs and the names in the drop down list. They should match 100% in order for it work Do you want to fix the names and send it back or would you like me to do that myself.
Ok, I had to correct the drop down list source data so it matches 100% the worksheet names
Here you go
The formulas are in the yellow cells on the Entry Tab worksheet
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the work.
Not sure I understand what you are trying to do, you seem to have typed data in the cells that have formulas thus erasing the formulas. Of course the formulas won't work any more because there are no more formulas in these cells. I am referring to the data that you have entered in rows 6 and 7.
If you want me to reinstate the formulas in these rows so they will pull the information from the relevant sheet let me know.
Please don't forget to click ACCEPT as this is the only way I get credit for helping. I will of course continue to assist if you need further assistance or if you have any question.
I'm sorry I don't understand.
If you want me to continue on this part please remember to click the accept button.
In the file that I sent you there are formulas in columns D thru J on the 'Entry Tab' sheet. These formulas read the selected Product in column A, and read the Page # XXXXX column C, then it will go to that Product sheet and look for that Page # XXXXX that sheet. If it finds a match it will pull the information from that row on the Product sheet and places that information in the corresponding column on the Entry Tab sheet.
Please review the above procedure and let me know which part, if any, you want me to modify.
I see. Ok so it is the other way around. The Products sheets should populate with data from the Entry Tab.
Ok in which row on each sheet would that data go. For example if you enter the following data on the Entry tab:
column A --> CRVI
column C --> 0056
in which row would the data go on sheet CRVI? will it be added to the bottom of the list (i.e. row 124), or will it replace any existing Pg # XXXXX ? or where?
Thanks for the additional information
Ok the only way that can be done is with a macro, and that because the result needs to be placed not in a fixed cell or row but rather into a variable location (e.g. first available row), and formulas can only return data in their own cells (i.e. cannot place data in other cells). I have however written the macro for that hoping you will be able to run in on Excel 2004 or another version of Excel (as I mentioned before Excel 2008 does not support vba macros).
Here is the file with the macro embedded in the Entry Tab sheet
(the download link is at the bottom of the page)
The macro is automatically triggered when the user changes the Product in any row on Entry Tab. So you need to first fill out the data in columns D thru J, then select the Product from the drop down list in column A. The macro will then copy the data from that row into the first available row of the selected sheet.
To access the macro right click on the sheet's tab at the bottom and choose View Code
Hope this helps. Let me know if you have any questions
You're welcome. Feel free to get back to me if you need further assistance with this