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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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,214,624
Messages
6,120,591
Members
448,973
Latest member
ksonnia

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