Can Excel transfer data From sheet1 to Sheet2?

[BM2006]

Hi,

I'm fairly new to this group and I just want to say thank you in advance for all the assistance anyone has and always shares.
I work in a fairly new call center and a lot of our data is ran manually, which can be a bit consuming and overwhelming to be working on multiple spreadsheets. With that being said, I created a spreadsheet and I have most of the formulas already enter with the exception of the main purpose of creating this spreadsheet. Our system runs a report that will provide every state and the amount of time an employee spends on the states daily. I than copy the information onto my worksheet master tab(Sheet 1). From there, I only need 4 out of the 196 states to transfer to the employees individual sheet.

Since the columns are not the same on each sheet, VLOOKUP is not an option. I don't want to delete anything from the master sheet because it provides me with other important data I use for other things.
I'm also familiar with the option of going to each employees sheet and using +'SHEET 1'!k3 but that is time consuming, especially when I have 28 employees and this is a running daily report for the year.

I really hope this is possible. Any help is greatly appreciated.

Sincerely,
BM2006

[Philb1]

Hi
The task you want excel to do should be easy enough to do, but I think you should get rid of all the merged cells before we start. Macros & merged cells don't get on well. If you want text centred across cells, try using centre across selection instead.

[BM2006]

Philb1,

Thank you for helping me.

I removed the merged cells. but I don't quite understand what you're asking to do with the text centred across cells. Can you walk me through it?

[Philb1]

You say the columns are different, that I presume means that the state numbers are going to be different for each employee?
The information for the date/state to be copied onto the employee sheet?

[BM2006]

The call states are the same for all the employees, but there is 196 call states and I only need 4 of those states transferred to each employees individual worksheet.

[Philb1]

Try this & see if it's what you're after
I changed the employee sheets a little & made them the same. You can change them if you want, but if you do keep them the same layout as it will make life much easier. The code will have to be adjusted if you do so the macro can put things in the right places.
Let me know how you go

As this useless website is still broken here's a dropbox link

https://www.dropbox.com/s/qy7dzff1g7...mple.xlsm?dl=0

Please Login or Register  to view this content.

Phil