Add Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet in which Columns A thru D contain data. The data is generated from formulas in columns AA thru DD. So cell AA1 feeds A1, cell AB1 feeds B1, etc. If I insert a column between column A and B, it does not automatically insert a corresponding column between AA and AB. IS there a workaround for this

Thanks!
 
Hi
not without using a macro/VBA. could this be a solution for you
 
Hi!

Does it surprise you that Excel doesn't go off and add some mor
columns?

It will if you tell it. That is not a work-around: that is your job!

Is there any reason why , when adding the column between A & B, yo
can't then add one between AA & AB? Manually or via VBA?

Al
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frank, Where are u? 1
Adding columns within a set of formulas 3
Sorting several columns 1
Search two columns in list for first and last name and return Id 4
Finding Corresponding Cell Value 2
Need to create dropdowns in Excel 1
help with inserting a cell value into a named formula 1
Extending a selection 1

Back
Top