Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: [HELP] Programming in Excel 2013

15 Jun 2015   #1
synth

Windows 7 Ultimate x64
 
 
[HELP] Programming in Excel 2013

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.


My System SpecsSystem Spec
.
15 Jun 2015   #2
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

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.
My System SpecsSystem Spec
16 Jun 2015   #3
synth

Windows 7 Ultimate x64
 
 

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.
My System SpecsSystem Spec
.

Reply

 [HELP] Programming in Excel 2013




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel 2013 has been crashing for over a year, HELP!!! Tried everything
I have a Toshiba P855 with 16GIGS of memory and Office 2013. I have been on the phone with Microsoft for 13 months complaining about how Excel 2013 Office Pro keeps crashing randomly. At first they told me my macro was corrupt. I knew it wasn't because it runs all day long on office 2010 on my...
Microsoft Office
New Excel 2013 BI stability and usability improvements
Source...
News
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
excel vba programming code
when i try to make an vba code in excel vba extension at the moment i added this line to the code of a button: Range("A1").End(xlDown).Offset(1, 0).Select it says there is an error but i did exactly what they said on this video https://www.youtube.com/watch?v=CzP8nO9UVvY its...
Customization
Excel 2013 Won't Automatically Open Files
I am running into a bizarre problem with Excel 2013 and I can't seem to figure out the cause - searching around I couldn't find a solution, either. I have both Office 2010 64-bit and Office 365 (2013) 64-bit installed on my Windows 7 system. The only reason I still need 2010 is that 2013's...
Software
Excel 2013 Opening Size of Sheet
First, I always close sheets in the position and size that I want them to open in. However, with my new Office 2013, when I open a sheet, or even first open Excel and it comes up with a new sheet, it's opens in a small window and the window is positioned in the left lower quadrant of my screen,...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:51.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App