Search for value. replace with formatting

R

rbmcc

Is it possible search for the value of cell A1 in all columns from C
onward and replace it with the value and formatting of B1, then so on
and so forth with A2/B2, A3/B3...etc.
So, basicly I have a list of values in column A and a list of
replacement values and formatting in column B and I want to apply that
to the rest of the spreadsheet.
 
R

rbmcc

bumpidy? I've yet to figure this one out, and assume by the reply it is
possible, just varries based on version
 
R

rbmcc

Bump? I hope that a bump every couple days isn't annoying. I'm sure
this is possible. But I'm terrible with macros. Never had much luck
programming in any sense :(
 

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

Document Merge Formatting Issue 0
Custom toolbar button for search and replace 1
Word macro that can call cells out of Excel for a find and replace 0
Printing Outline view - formatting lost 0
VBA Coding Help for Beginner 0
WORD VBA Search and switch to advanced ... 1
Prompt For Replace in Selection And More... 0
Calculate the median value before a specified list 0

Top