asked on

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

NBVC

In Tab2, B1:

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

in B8 of Tab2:

='tab1'!A34&""

copied to C8 and down as far as you want

J_Drake

ASKER

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,

NBVC

You mean?

='tab1'!B10&" - "&'tab1'!A15

Steven Harris

Just for fun, I added a button to process the move.
Test--1-.xlsm

J_Drake

ASKER

Is there a way to check if a task is added on tab 1 to add a item number in column a tab2?

Thanks,

NBVC

Try this formula, in A8:

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

copied down

J_Drake

ASKER

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!

ASKER CERTIFIED SOLUTION

NBVC

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

J_Drake

ASKER

yep..that did the trick thanks! :)

NBVC

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?

J_Drake

ASKER

Just re-posted..thanks!