AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN.

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

Guest

I would like to set my worksheet to display either column H or column G
depending on the content in column A such as if column an content is monday
would automatically display column G if column A in sunday would
automatically display column H is this possible?
 
I would assume that you would have Monday, Sunday, etc as the column header.
Then use match on row 1 to find the column and go from there.
 
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

Help needed 0
Problem sorting a range of columns using VBA 1
Compare Two Columns 3
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
moving columns 12
Conditional Formatting with VBA 4
Macro to look up values in 2 different columns 3
VBA set thick borders around non empty cells in range 0

Back
Top