+ Reply to Thread
Results 1 to 2 of 2

Newbie Needs Help with VBA/Macro

  1. #1
    Registered User
    Join Date
    11-16-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Question Newbie Needs Help with VBA/Macro

    Hello all. I'm using Excel 2010. Though I'm not new to office by any means I've never found myself needing to write vba/ a macro. I am responsible to two reports a tax exempt report that's auto generated by our system on a day to day basis and a tax recon report that manually take the info I need from the tax exempt report and type into the recon report. Normally it's only a couple of pages and takes just a few moments but my company has a group coming up that will have hundreds of people for multiple days that are all tax exempt and the report will be in the 50 or so page range. Manually transferring the data over would I'm guessing take days. I was hoping I could get some help to make a macro or write some vba code that would run in the tax exempt report and out a new xlsx sheet with just the data I need so that I can simply cut and paste in into the tax recon report (it's locked so I can't edit any fields other than the data I'm supposed to enter and macros / vba has been locked as well) and example of what my tax exempt report looks like is this:
    exempt.jpg

    My tax recon report looks like this:
    recon.jpg


    I only need from the exempt report Column A the date (minus the header), Column D the name, and here is a tricky part. If Column F says Occupancy Tax then Column I goes into one spot and if Column F say Room Sales Tax Exempt Column I goes into a different spot on the recon report.


    Thanks for any help you can give me!

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Newbie Needs Help with VBA/Macro

    Hello KrumFox,

    Welcome to the Forum!

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    And unfortunately; Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Macro - Newbie
    By gigglesmumpty in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-05-2016, 05:19 AM
  2. Hellos, another newbie here. An old newbie 31 years just started to use VBA!
    By vba_newbie83 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-31-2014, 03:37 AM
  3. Newbie in Macro
    By Carbonlink in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-20-2014, 07:45 PM
  4. complete macro newbie
    By savfam02 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2010, 09:14 PM
  5. Newbie: VBA? Macro? Please Advise...
    By pollywog1961 in forum Excel General
    Replies: 1
    Last Post: 05-29-2006, 02:57 PM
  6. newbie macro question
    By Knox in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2006, 01:10 AM
  7. Newbie - Help with a macro
    By Mike Basden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2006, 08:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1