Extracting several individual cells from excel file

User-to-User discussion about the PhraseExpress macro programming.
Post Reply
slaterians
Posts: 1
Joined: 04 Dec 17, 10:46

Extracting several individual cells from excel file

Post by slaterians » 04 Dec 17, 11:10

I am trying to extract several different cells of information across a row of excel data. I am using the macro below to search for result on column 2 then extract the data from column 3 to column 11 and this works great.

{#xls -col 3 -row {#getxlsrow -search {#input -head User Id? -single -required} -file C:\Users\ian\Desktop\orders\master.xls} -endcol 11 -file C:\Users\ian\Desktop\orders\master.xls -colseparator {#ENTER}}

but i also need to extract data from column 28 and column 33. Do I need to include separate macros for each request including the user input search or is there a way of doing this all from one macro?

Hope the above makes sense. Thanks Ian.

Post Reply