Find and replace data from multiple columns using Macro

[anup.behera86]

Hi Everybody,


I am novice in macro writing and it would be a great help if anyone can provide their inputs to my queries mentioned below:

I have a excel file named Floor mapping.xlsx with two sheets,

1. Picking density

2. Layout


First the macro should create a backup sheet of Layout i.e. Layout(2) and make changes to it as the original file needs remain intact. Picking density is the sheet where user inputs the values which needs to be searched and replaced from Layout(2) sheet. The user enters values in two columns : A and B as mentioned below:


For eg

ColumnA Column B

R09A 15

R10A 14

R09B 35

R12E 60

R10E 110


The macro picks the R09A value i.e A1 and checks the entry in Layout(2) sheet. If found it replaces it with the value B1 i.e. 15


Also, the number of entries are variable i.e sometimes user enters 5 values A1-A5 and sometimes 10, A1-A10. The macro needs to calculate this automatically.


Please let me know how to proceed with it.


Thanks,

Anup

 

[SirJB7]

Hi, Anup!


I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, well, come back here, tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your questions...

Could you please consider uploading the file? It'll be very useful for people who might help you.


Regards!