Copy of a Row

[Steved]

Hello from Steved

Question Please.

Copy of a Row from Col A1 to Q1

This is what I am trying to acheive.

I have Sheet1 as a master
I have a Sheet2 to Sheet10

I have in Cell E1 is a number "86041", in this case to
sheet8 Is their a Formula I can put in Sheet8 that will
copy Cell A1 to Q1, Cell E1 the identifier.

Thankyou.

 

[Bob Phillips]

From BobP

Steve, not sure I get you. What does the 86041 signify, and what sheet is it
on? Do you want to copy A1 to Q1 from the master?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Steved]

Hello Bob From Steve Dee

Yes I am asking is it possible to copy from A1 to Q1.
The copying will be from the master Sheet "Sheet1".
86041 is a customer Number, which is in "Cell E1".

Because 86041 is an unique number I am asking That
using "Col E" is it possible to have a formula that
can read A1 to Q1, if so copy it to Sheet8.

The first numeric is between 2 and 9 hence I have
Sheet2 to Sheet9. Each day I have up to 30 customers
ie 20479, 37658, 43211, 57889, 62234 and 76582 all need
to be copied to their particular Sheet ie 57889 in this
case will go to Sheet5. I am wanting to have a Clean
master Sheet each new day.

Thankyou.

 

[Bob Phillips]

SteveD,

Here is one way.

In R1 on the master sheet, add this formula
=VALUE(LEFT(E1,1))
and copy down.

Then on Sheet2, add this formula in A1
=IF(Sheet1!R1=2, ROW(),"")
and copy down to the same number of rows on Sheet 1

Then of F1 on Sheet2 add this formula
=IF(ISNUMBER(SMALL(IF($B$1:$B$6="","",ROW($B$1:$B$6)),ROW(1:1))),INDIRECT("M
aster!"&CHAR(COLUMN()+64)&SMALL(IF($B$1:$B$6="","",ROW($B$1:$B$6)),ROW(1:1))
),"")
this is an arrya formula, so commit with Ctrl-Shift-Enter.
Copy across to Q1, and down the full number of rows.

Repeat this on sheets 3-9, just just the 2 in the middle formula with the
sheet number.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)