Formula o Macro para decirle a Excel desde que celda quiero empezar a copiar la información ≈ Micros

%3CLINGO-SUB%20id%3D%22lingo-sub-1936383%22%20slang%3D%22es-ES%22%3EFormula%20or%20Macro%20to%20tell%20Excel%20from%20which%20cell%20I%20want%20to%20start%20copying%20the%20%E2%89%88%20Micros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936383%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20afternoon%3C%2FP%3E%3CP%3Emy%20intention%20is%20by%20means%20of%20a%20formula%20or%20macros%20to%20tell%20excel%20from%20which%20cell%20I%20want%20to%20start%20copying%20the%20information%20I%20have%20on%20one%20sheet%20to%20another.%3C%2FP%3E%3CP%3EI'm%20going%20to%20try%20to%20be%20more%20detailed.%3C%2FP%3E%3CP%3EThat%20in%20the%20SOURCE%20sheet%2C%20being%20able%20to%20designate%20from%20which%20cell%20I%20want%20you%20to%20start%20copying%20the%20information%20to%20the%20DESTINATION%20sheet.%20And%20what%20I%20designate%20in%20the%20Source%20blade%20can%20be%20changed.%3C%2FP%3E%3CP%3EI%20need%20this%2C%20because%20I%20put%20a%20price%20template%20in%20excel%2C%20those%20prices%20are%20then%20printed%20on%20a%20self-adhesive%20die-cut%20sheet.%20But%20sometimes%20the%20prices%20don't%20complete%20the%20template%20or%20I'm%20halfway%20there%20or%20sometimes%20it's%20a%20single%20price%2C%20so%20being%20able%20to%20tell%20you%20from%20which%20cell%20I%20want%20you%20to%20start%20copying%20the%20info%20I%20could%20take%20better%20advantage%20of%20the%20self-adhesive%20template.%3C%2FP%3E%3CP%3EI%20hope%20I've%20been%20able%20to%20make%20clear%20what%20I%20need.%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3CP%3EBest%20regards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936383%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938642%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20o%20Macro%20para%20decirle%20a%20Excel%20desde%20que%20celda%20quiero%20empezar%20a%20copiar%20la%20informaci%C3%B3n%20%E2%89%88%20Mi%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F435213%22%20target%3D%22_blank%22%3E%40JesicaT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20help%20us%20help%20you%20if%20you%20could%20post%20a%20copy%20of%20your%20workbook%20here.%26nbsp%3B%20Without%20that%2C%20despite%20your%20explanation%2C%20we're%20forced%20to%20do%20a%20lot%20of%20guessing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20one%20possible%20solution%2C%20but%20it's%20just%20a%20guess%3A%20%3CEM%3E%3CSTRONG%3EHave%20you%20tried%20the%20newly%20available%20FILTER%20function%3F%3C%2FSTRONG%3E%20%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Buenas tardes,

mi intención es mediante una formula o macros decirle a excel desde que celda quiero empezar a copiar la información que tengo en una hoja hacia otra.

Voy a intentar ser mas detallista.

Que en la hoja ORIGEN, poder designar desde que celda quiero que empiece a copiar la información en la hoja DESTINO. Y lo que designo en la hoja Origen se pueda cambiar .

Necesito esto, porque arme una plantilla de precios en excel, esos precios después se imprimen en una hoja troquelada autoadhesiva. Pero a veces los precios no me completan la plantilla o me quedan a la mitad o a veces es un solo precio, entonces pudiendo indicarle desde que celda quiero que empiece a copiar la info podria aprovechar mejor la plantilla autoadhesiva.

Espero haber podido dejar claro lo que necesito.

Desde ya muchas gracias.

Saludos.

1 Reply

@JesicaT 

 

It would help us help you if you could post a copy of your workbook here.  Without that, despite your explanation, we're forced to do a lot of guessing.

 

Here's one possible solution, but it's just a guess: Have you tried the newly available FILTER function?