Automatically transfer data from one worksheet to various others [Closed]

Report
Posts
1
Registration date
Wednesday January 20, 2016
Status
Member
Last seen
January 20, 2016
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
Hi,

I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) are filled in, TFS from worksheet 1, is filled in.

1.Worksheet 1 contain the following table headers:
Case Number,TFS,TFS Status / Case Status, Priority,Subject,Asset Name, Company,POC,Date/Time Opened,Closed, and Notes


2.Worksheet 2 contains the following table headers
Case Number,TFS/Task ,TFS Created On,TFS status / Notes

For example when I enter a number under the column TFS on worksheet 1 the TFS number along with the rest (case number, TFS Status, Notes ) is transferred over to worksheet 2. Every time the transfer occurs Excel should input the current date for each "TFS Created On" cell.

Thank you for helping me with this :)

1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello 621carrots,

There's some confusion in what you are explaining /trying to do. Your thread title mentions "............from one work sheet to various" yet your post only mentions sheets 1 and 2.

The headings are somewhat of a jumble but I assume that they would be the same (description and number of) in each sheet.

It would be best if you could upload a sample of your work book so that we can properly assess what you are trying to do. You can upload a sample by using a free file sharing site such as DropBox, ge.tt or SpeedyShare then post back here the link to your sample file. Remember to be careful with any sensitive data.

Cheerio,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!