Copying One column into Two columns

G

Guest

Hi,

I have a column of values of finance data. ColumnB with 10 values
($10,$20,$30,$40,$50,$60,$70,$80,$90,$100).

User is prompted to select a row of these 10 rows. Suppose user selects
row#5 with $50 value.

How should I copy the values UPTO row#5 of Column B and paste in Column C
without hardcoding?
How should I copy the values AFTER row#5 UPTO row# 10 of Column B and paste
in Column D, STARTING FROM ROW 6 without hardcoding?

Thanks...Appreciate your help.
 
D

Dave O

When you say "the user selects row 5 with a $50 value", how does he
select it? By landing the cell cursor on row 5? Typing "5" into an
input box, or into a cell? Your solution depends on how you're
collecting data. The ultimate answer will likely include a SUM and
OFFSET formula, but determining the arguments and where they come from
is the question mark for me right now.
 

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

Splitting Column in to 2 columns 1
Column seggregation 2
insert row when sum of values equals 100 3
insert row when sum of values equals 100 2
transpose multiple rows into one column 2
CONCATENATE by criteria and range 1
Excel Subtracting multiple columns from another column 3
alternative formula for VLOOKUP since it stops with the 1st value itself 2

Top