?
Solved

Excel Problem

Posted on 2014-01-24
11
Medium Priority
?
194 Views
Last Modified: 2014-01-28
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
Comment
Question by:J_Drake
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
11 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 39807231
In Tab2, B1:

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

in B8 of Tab2:

='tab1'!A34&""

copied to C8 and down as far as you want
0
 

Author Comment

by:J_Drake
ID: 39807284
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
 
LVL 23

Expert Comment

by:NBVC
ID: 39807290
You mean?

='tab1'!B10&" - "&'tab1'!A15
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 18

Expert Comment

by:Steven Harris
ID: 39807304
Just for fun, I added a button to process the move.
Test--1-.xlsm
0
 

Author Comment

by:J_Drake
ID: 39807539
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
 
LVL 23

Expert Comment

by:NBVC
ID: 39807575
Try this formula, in A8:

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

copied down
0
 

Author Comment

by:J_Drake
ID: 39807685
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
 
LVL 23

Accepted Solution

by:
NBVC earned 1600 total points
ID: 39812049
Do you mean in B8 of Tab2:

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

copied down.
0
 

Author Comment

by:J_Drake
ID: 39815345
yep..that did the trick thanks! :)
0
 
LVL 23

Expert Comment

by:NBVC
ID: 39815676
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
 

Author Comment

by:J_Drake
ID: 39815686
Just re-posted..thanks!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question