Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying One column into Two columns
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying One column into Two columns
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
creating a bar graph | Excel Discussion (Misc queries) |