Copying Data to the correct Sheets

bradt503

New Member
Joined
Aug 31, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello All, here's my Problem: I recently got a promotion one of my duties is to enter data from physical sheets into two different excel files. Everyday I get a stack of paperwork. I first have to alphabetize the paperwork by client name, then I go about emailing the clients about the services we provided, I enter that information into an excel file I will be calling the "Callback List", as well as additional information stating who I contacted and when. After I get through that I then have to open up a separate excel file that has over 100 sheets, each sheet is for a different client. I then have to re-enter much of the data again into each client's respective sheet.

What I'm hoping is that I can enter the information once into my callback sheet and that the data will be ported into the correct sheet. Please help, I hate doing a task twice.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Fast answer needs visual help.
Try to attach a mini sheet via XL2BB, or attach a sample wb via google drive or toolbox...
 
Upvote 0

Forum statistics

Threads
1,215,343
Messages
6,124,404
Members
449,156
Latest member
LSchleppi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top