• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help!

M

MissHJL

New Member
Hi there,

I am working on a spreadsheet that I have so far managed to get to run smoothly using formulas. Unfortunately, without using a stupidly complicated formula in each individual cell, I am now stumped.

I am trying to get the information from the "Selections" tab, copies into the "Sheet 1" Tab, but only the catagories in "Sheet 1".

I know that I will probably need a VBA but I don't have any experience in this, and whilst I am trying to learn, I need to get this done ASAP for work.

I've attached the spreadsheet.. if anyone can help and guide me as to how to insert a VBA that will do what I need it to do, that would be SO helpful!!

Thank you!!
 

Attachments

Hi:

What are you trying to achieve here, please give more background as far I can see you are trying to pull the same info to a different tab but with fewer columns than your Selections tab.

Thanks
Nebu
 
I need the information (that is seen on "Sheet One") to populate from the Selections Tab as long as "Confirm Hire" is ticked "Yes".

If it's ticked No, I don't want it to be populated.
 
Can I ask for a link to learn how to use pivot tables?

Thank you so much!! How do I refresh the table so that I can keep adding lines if I need to?
 
You must log in or register to reply here.
Back
Top