extract projects hours, employee numbers, etc... and create a list

[Duncan.A.Lau]

So for my internship I have to find a way to take the data from all of the employees' time sheets and put them into one master list/sheet. Is there anyway to grab all of the projects they've worked on, their hours, employee numbers, etc... and create a list that auto-pulls from those sheets (without using macros)? I'm terrible in excel and like super lost, so if you have any insight that would be amazing!

Best,

Duncan

[FDibbins]

Hi, welcome to the forum

For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

I have changed it for you - this time

To your question - yes, we can probably help with this, but it would be helpful if we could see a (CLEAN) sample of what you are working with and what you expect.

[Duncan.A.Lau]

Hi! Sorry about that I'm new to the forum. I noticed on other pages that people were attaching files to their posts, how can I do that?

Best,

Duncan

[FDibbins]

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Duncan.A.Lau]

When I tried to upload the file it said the file upload failed, I tried uploading it again as an xlsb with the same result. Maybe it's the size? Is there a way to shrink or reduce the file size?

Best,

Duncan

[Duncan.A.Lau]

scratch that figured out how to decrease file size sorry

[FDibbins]

We only need a small representative sample of your data. Just enough to show what you have, and what you want.

edit: I just opened your file. Can you provide some sample data, and expected outcome please?