Good morning Fellow Excelers,
Having a few issues trying to nail a VB porject I have going on here. I have attached the files, in a workbook setup. First off what Im trying to get accomplished if its possible, Is a VB tool that will allow the connected Billing sheet be auto populated with information from the CO2 Log when the information is input into one cell. What IM trying to do is have the Information in column C of the CO2 report to the billing sheet, once the number in column c is input into the billing sheet in I4-J4, all associated info on the rest of that table gets input into corresponding spots on the billing sheet. So than as the file shows all of that information they would need populates into the corresponding spots on that billing sheet. It has where the info should transfer too already shown on the attached. I have another thread/stream written for another form I use that I altered to try and accomplish the same task but unfortunately I dont think it will do what I need as the info that was transfering to the same layout is just to another sheet. So like table for like table, this information needs to get split up and input into the associated places. Any assitance would be more than appreciated. Thank you for your time.
Anthony