Advertisement

05.30.2008 at 07:59AM PDT, ID: 23444801
[x]
Attachment Details

Excel 2000:  Macro to automatically change data/ repost

Asked by jmillerCTG in Microsoft Excel Spreadsheet Software

I am reposting this question.  I am trying to set the same thing up on a different user's PC, but I am not getting it to work.   Thanks.

I have two things that I would love to do automatically.   I was hoping to do it with a series of macros, but since the number of rows of data changes on a weekly basis, I don't think it will work.    Is what I am wishing for even possible?   I will upload the before and after files now. Thanks.

1.  The data in column B gets modified based on the data in Column A.    The 3rd digit in column A gets added to the front of the data in column B.  

2.  If the data in column A is a 0, it gets replaced based on the cell directly above it.    
     
      1xxxxx      100001
      2xxxxx      200001
      3xxxxx      300001
      4xxxxx      400001
       xxxxx      02xxxx     (0 or blank in the reference cell)

NOTE:  Any cell containing 21300 in column B is never changed.

**sample**
BEFORE:
A                B             C
306500      3100      143.62
306500      3500      1202.26
0                21300     -1345.88
127100      2100      3.5
127100      3100      309.89
127100      3500      145.15
127100      6900      5.47
0                21300     -464.01
           
AFTER:
A               B              C
306500      63100      143.62
306500      63500      1202.26
300001      21300      -1345.88
127100      72100      3.5
127100      73100      309.89
127100      73500      145.15
127100      76900      5.47
100001      21300      -464.01Start Free Trial
[+][-]05.30.2008 at 10:16AM PDT, ID: 21679623

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 10:20AM PDT, ID: 21679656

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 10:33AM PDT, ID: 21679770

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 11:30AM PDT, ID: 21680253

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 11:33AM PDT, ID: 21680271

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 11:44AM PDT, ID: 21680373

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:03PM PDT, ID: 21680521

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:08PM PDT, ID: 21680568

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:15PM PDT, ID: 21680623

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:38PM PDT, ID: 21680781

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:41PM PDT, ID: 21680812

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:44PM PDT, ID: 21680836

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:46PM PDT, ID: 21680857

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:51PM PDT, ID: 21680897

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 01:11PM PDT, ID: 21681073

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Sign Up Now!
Solution Provided By: chris_bottomley
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.04.2008 at 10:43AM PDT, ID: 21712283

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.04.2008 at 12:12PM PDT, ID: 21713099

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628