copy entire column instead of rows

**shido** · 08-28-2015, 09:18 PM

Hi Alan.

Thank you for your reply.

Please see attached sample spreadsheet. I have three worksheet “Master List”, “Awaiting” and “Remove”.
1. Row 1:1 will have dropdown “Master”, “awaiting” and “Remove” in all worksheet.

2. All three sheets have “Name” in A1:Ax”, x is a variable number. However, “Name” will either be same or different name in three worksheets.

3. When the user select “Awaiting” in “Master” worksheet

a. I would like to compare Name list in the Awaiting or Remove worksheet

b. If “Name” matches, Copy selected column from “Master” worksheet and move to the “Awaiting” or “remove” worksheet based on the dropdown selection.

c. However, if “Name” does not match in either of the sheet, update the “Name” by adding row and then copy the selected column.

I hope I have explained the basic functionality of how I want the spreadsheet to work.

Thank you for your time and effort.

Regards

sample.xls

**Doc.AElstein** · 08-29-2015, 04:25 AM

Hi,

Originally Posted by shido

.......hope I have explained the basic functionality of how I want the spreadsheet to work......

. I think i can guess close to what you want, but just to be sure I do not waste time if I have guessed wrong..and to help me .........

.1)

Originally Posted by shido

.....
When the user select “Awaiting” in “Master” worksheet
......

I see no “Awaiting” in “Master” worksheet ???

................................
. 2 )

Originally Posted by shido

.....All three sheets have “Name” in A1:Ax”, x is a variable number. However, “Name” will either be same or different name in three worksheets.

You mean “A3:Ax” ?

... OK. Try this:
. I return a File which I will call “Before”. I have changes the data in Master such that it would help me better to check and debug any program. I have deleted all data in the other sheets
. Please modify that file ( Presumably the other sheets ) so that the data looks as it typically might be based on my data in Master. Remember to include the possibility of all scenarios such as missing names etc, etc,..
. Return that file to me as the Before
.
. Now working on a copy of that Before modify it manually to reflect the changes you want to occur after the running of the code I do for you.
. And explain again carefully what you did or would do to initiate that change.
. Return that second file to me as the After
.
. So I await 2 files from you. ( Unless you feel in the mood to give me another After just to make it crystal clear to me what you want )

Alan
. If you can get that info across I will do it for you today or early tomorrow.