Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Excel database link keep rows aligned

Avatar of stealthwifi12
stealthwifi12Flag for United States of America asked on
Microsoft AccessVisual Basic ClassicMicrosoft Excel
9 Comments1 Solution1618 ViewsLast Modified:
Ok I have a hard time explaining this one so bare with me:

I have an Excel 2007 Workbook with one Sheet (Form) with an outside data connection (MySQL database) The data from the database is dumped in rows B-G. What I need is a way to mark say cell A2 and have that stay with the data in that row, so if A5 contained the word Ordered and B2-G2 contained the data from the database and someone removed that data it would throw off the rows making A5 next to what used to be B-G6 (since the values from B5 where removed)

How do I keep things aligned, is there an excel trick or some VBA that can keep things in order?
(I can pull in the unique ID field from the database table if that would help)
Avatar of stealthwifi12
stealthwifi12Flag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers