• 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.

Auto-populating data from two sheet

N

Navs

New Member
Hello,

I have used this forum once before and have got the perfect solution. I am back here with another VBA problem that I am unable to solve. Any assistance will be greatly appreciated.


I have 3 sheets: Project GB, Project NA and Project EM. Users can update data only in sheets Project NA and EM. All the sheets are formatted and cells have alternating colors in them (blue, shite, blue, white). So here are my questions:


1. How do I make the Project GB sheet dymanic to automaticaly update based on inputs in other 2 sheets keeping the formatting and colors intact.

2. Macro to add rows on a button click in sheets NA and EM, again keeping the overall formatting and colors intact.

3. Is there a way to run a macro and autofit data in cells?


Thanks for all your help.
 
Navs

When you say to make Project GB Dynamic?

Do you mean that Project GB is a straight copy of the data on the other two sheets ?


Can all what you trying to do, be done using Excel Tables, they will maintain alternate colors, cell formats etc and use a simple formula on Project GB to bring the data across from the two sheets


Can you please elaborate?
 
You must log in or register to reply here.
Back
Top