Finding data in other sheet and splitting cells

[sentinela]

Hello everyone,

I am working in this spreadsheet for service work order, and I need to create a report for it and make sure that I have all the data. On sheet "Totals" is where the customer#, name (john) (smith) two separate cells, service date, and amount needs to come for the report. On sheet "Data" I have cust#, name (smith, john) one cell, and service date(which is a specific date). On the sheet "Amount" is their cust#, date of service (which could be several dates), and amount.
On "Total" sheet, I need the following results...
- I have customer number on column A
- First name - column B (from data sheet)
- Last name - column C (from data sheet)
- Amount on the day according to data sheet - Column D
- Date (from data sheet) - column E

Any ideas on the code?

Thanks!

[Leith Ross]

Hello sentinela,

You will get an answer faster and reduce the number of questions and answers about your problem by attaching the workbook. Formatting, especially on invoices and the like, can create challenges to producing the final result. If you have sensitive or confidential information in the workbook, please make a copy of the workbook and either remove that information or change the names to protect the innocent.

I grew up in Asheville. Where are you located in the Tar Heel state?

[sentinela]

Thanks Leith,

Here is the sample book. I hope this will help understand my position.

I am about 20mi west of Ashville, NC. Right on the foothills!

Thanks for the help!

[Leith Ross]

Hello sentinela,

Thanks for the workbook. This makes things much easier. So are you near Canton or Haywood?

[sentinela]

Forest City...

Does that ring a bell to you?

[Leith Ross]

Hello sentinela,

I have been out there a few times. That was a long time ago back when I was teen. I should have this working within the hour.

[sentinela]

Next time you come, let me know... I will take you to an awesome restaurant for a meal!

[Leith Ross]

Hello sentinela,

Want to double check that I am doing this right. All the information on the "Data" sheet needs to be transferred over to "Totals" sheet with the names being split, right?

[Leith Ross]

Hello sentinela,

Here is the macro. I have attached this to a button on the "Totals" sheet. If this isn't what you need, let me know.

Please Login or Register  to view this content.

[sentinela]

Great Leith,
Thanks for the help.

Now, when I put in my spreadsheet, I remembered, actually needs to be looked up by account number. For I have many accounts that are listed in the total and some on them might be dormant.

Thanks for all your help!

[Leith Ross]

Hello sentinela,

Did you want to update the macro?

[sentinela]

If you can that would be great!

Thanks for all the help!