Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Excel Problem

Hi All,

I need to push data from one tab to another based on a users input.

-User inputs into b10 & a15 on tab1 and combine the fields then populate in B1 tab2.

- I also need to, push fields "task" & to "performed by" on tab1 to "task" and "champion" tab2.

Any help would be greatly appreciated.

Thanks,
JD
Test.xlsx
0
J_Drake
Asked:
J_Drake
  • 5
  • 5
1 Solution
 
NBVCCommented:
In Tab2, B1:

='tab1'!B10&'tab1'!A15

in B8 of Tab2:

='tab1'!A34&""

copied to C8 and down as far as you want
0
 
J_DrakeAuthor Commented:
Thanks for the quick response.

Is there a way to add this format to the cells being combined.. 1234 - abcde  

The space - space format.

Thanks,
0
 
NBVCCommented:
You mean?

='tab1'!B10&" - "&'tab1'!A15
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Steven HarrisPresidentCommented:
Just for fun, I added a button to process the move.
Test--1-.xlsm
0
 
J_DrakeAuthor Commented:
Is there a way to check if a task is added on tab 1 to add a item number  in column a tab2?

Thanks,
0
 
NBVCCommented:
Try this formula, in A8:

=IF(B8="","",COUNTA(B$8:B8))

copied down
0
 
J_DrakeAuthor Commented:
I may need to expand the task section on tab1. Is there a way on tab 2 to do a check for this expansion and not include anything if it hits the header "resources" in column a on tab1.

Many thanks!
0
 
NBVCCommented:
Do you mean in B8 of Tab2:

=IF(OR(B7="",'tab1'!A34="Resources"),"",'tab1'!A34&"")

copied down.
0
 
J_DrakeAuthor Commented:
yep..that did the trick thanks! :)
0
 
NBVCCommented:
Hi,  I saw another question of yours and was about to post a reply when it told me that the question was deleted...  Did you delete your question?
0
 
J_DrakeAuthor Commented:
Just re-posted..thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now