how do I change 5000 cells from DSDDE|Times!'V2647:B' to DSData|

R

Roy the rooster

How do I change 5000 cells from DSDDE|Times!'V2647:B' to
DSData|Times!'V2647:B' Where the 2647 is a different number in every cell
 
M

mcpie

if i've understood correctly, you could try a Find and Replace (ctrl + F) with
Find: DSDDE|Times!
Replace: DSData|Times!

Hope this helps
 
C

CLR

Edit > Replace > Replace: DSDDE > ReplaceWith: DSData > ReplaceAll

Vaya con Dios,
Chuck, CABGx3
 
Top