Jump to content
Macro Express Forums

Using An Excel Formula With Me


renee
 Share

Recommended Posts

I have a list I create and it lists doctor's name, except if a patient has already been discharged. then it says "automatic discharge". What I want to do is delete automatic discharge and replace it with the information in the same row in column aj.

 

right now I type in =row#aj and it replaces the text. then I have to copy and paste as just plain text because i then delete all the columns from about Z to AJ. for those of you who know Excel you will understand. If not, don't worry about it.

 

So my question is this: Can I make ME recognize the row? It changes everytime I download the document. I don't want to have to create a new row and write an IF statement if I don't have too ;) - Any help would be appreciated.

 

Renee

Link to comment
Share on other sites

Well, there's no magic to this. You need to work out how you would do this manually yourself (i.e. record the keystrokes you would use to achieve what you want), then you should be able to create a macro to replicate those keystrokes (and you'd need to allow sufficient pauses between different keystrokes to prevent your macro getting ahead of itself).

Link to comment
Share on other sites

Well, Paul you are right, except what I do now is scroll down until I find the text and then type =whatever row its on aj. So I was trying to figure out how to get the macro to recognize the row. But I just had an idea. I might be able to search and then replace it with an If statement. I'll try that - thanks - Renee

Link to comment
Share on other sites

  • 1 month later...

This code is how you go to a specific cell in Excel. I used Cell A1 for this example:

 

<TEXTTYPE:<ALT>eg><TEXTTYPE:A1<ENTER>>

 

Once you're in the first column of the row you want, highlight the entire row by using:

 

<TEXTTYPE:<CONTROL><SHIFT><ARROW RIGHT>>

 

(If you have an empty column, this command will need to be repeated so the entire row is highlighted.)

 

A1 could easily be set as a variable so it can be adjusted on the fly.

 

I know this post is old ... hopefully it will help someone who has a similar need.

 

Brad

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...