Use Button to start macro to check column for entry then move row to bottom of other sheet

**ghoshl1** · 08-27-2012, 10:25 AM

Hi All,

This is kind of complicated so I'll try to describe in steps:

1. Open worksheet (library)
2. Identify what group (this is like Test A) so this cell would be "A", "B" etc.
3. This would identify what Test sheet to send this information to. (when entry is B - send data to worksheet Test B when macro button selected).
4. Then Check column F for "X"
5. For each row that there is "X" copy columns B,D to worksheet "Test B" at the bottom of empty rows, in specified columns A,B. (don't delete original).

I went through the threads but couldn't find quite like this...

Help???

**venkat1926** · 09-08-2012, 08:18 AM

sorry not clear to me

let me rephrase
there are two sheets testA and testB

check in sheet testA for a value "x" in column F of that sheet
if found copy the entries in column B and D of that row where x is found and copy these two cells
in column A and B after the last row in sheet testB
find any othr x is testa column F and do the ssme thing

I am not giving the code for operning the file becaue better open the file manually so
that you can operate the macro in that file

the macro will be

Please Login or Register  to view this content.

I am also attaching the file for easy reference

**ghoshl1** · 09-10-2012, 03:02 AM

I'll try this soon and get back to you - thanks!!

Use Button to start macro to check column for entry then move row to bottom of other sheet

LinkBack

Thread Tools

Rate This Thread

Display

Use Button to start macro to check column for entry then move row to bottom of other sheet

Re: Use Button to start macro to check column for entry then move row to bottom of other s

Re: Use Button to start macro to check column for entry then move row to bottom of other s

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions