[HELP] Programming in Excel 2013

[synth]

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.

Cheers.

 

[strollin]

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

 

[synth]

I understand, I'll be posting some screenshots below of how our current table for reports looks like and i'll try my best to explain what our current process is and what I want it to be.

First of all I've edited the excel file and for security reasons, for the titles in the first columns of the tables, i've placed what will be the data type of the contents of the cells below it. Please refer to the screenshots below.

Ok, so basically here's what I'm planning on doing, I want to create a macro that will copy certain data on the Track worksheet and transfer it either to the Shift1, Shift2, or Shift 3 worksheets. Also, if possible, I'd like to group them in the tables found in the Shift1 or Shift2, or Shift3 worksheets. They will be grouped by a certain identifier which is a string.

Additional info, if you'll notice the screenshot of the Track worksheet, there are some hidden rows in it, that's because all the data placed in there are for the whole month. So everyday we put different data in there, and everyday we need to filter them to create the daily reports. So I was thinking of using the If Then statement for VBA, and use the dates as the identifier if wether they should be copied from the Track worksheet to the Shift worksheets.

If you guys need more info, please let me know. I've played around with VBA today, and I was able to achieve what I wanted to do when I declared specific cells to copy to another specific cell in the Shift worksheet.

Thanks.