Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
hello everyone.
can someone give me a sample code that could scanned a column for non-blank cell of another worksheet and retrieve data to be entered to another worksheet. honestly, i don't know how to make a macro but i've read it could be done with looping statement. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
Do you want that non-blank cells should be copied to another worksheets?
alex wrote: hello everyone. can someone give me a sample code that could scanned a column for non-blank cell of another worksheet and retrieve data to be entered to another worksheet. honestly, i don't know how to make a macro but i've read it could be done with looping statement. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200901/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
yes, i need to copy non-blank cells to another worksheets. it's really
comlicated to explain since there will be set of conditions to the whole process but yes generally that's what supposed to happened. this would be the first time i actually be doing macro. "aamerrasheed via OfficeKB.com" wrote: Do you want that non-blank cells should be copied to another worksheets? alex wrote: hello everyone. can someone give me a sample code that could scanned a column for non-blank cell of another worksheet and retrieve data to be entered to another worksheet. honestly, i don't know how to make a macro but i've read it could be done with looping statement. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200901/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
The macro recorder can be your friend. Record a macro while doing datafilterautofilternon blankcopypaste -- Don Guillett Microsoft MVP Excel SalesAid Software "alex" wrote in message ... hello everyone. can someone give me a sample code that could scanned a column for non-blank cell of another worksheet and retrieve data to be entered to another worksheet. honestly, i don't know how to make a macro but i've read it could be done with looping statement. thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
Thanks Don, but the data i want to copy needs to meet certain conditions. how
could i attached a file so i could explain it better. "Don Guillett" wrote: The macro recorder can be your friend. Record a macro while doing datafilterautofilternon blankcopypaste -- Don Guillett Microsoft MVP Excel SalesAid Software "alex" wrote in message ... hello everyone. can someone give me a sample code that could scanned a column for non-blank cell of another worksheet and retrieve data to be entered to another worksheet. honestly, i don't know how to make a macro but i've read it could be done with looping statement. thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
sample macro
You can post to free shared sites like: 4shared.com, box.net and
mediafire.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I random sample from a set until every sample is selected? | Excel Discussion (Misc queries) | |||
Any macro programming sample for accessing database through Excel? | Excel Programming | |||
sample macro for printing by selection | Excel Programming | |||
Sample spreadsheet of using macro | Excel Worksheet Functions | |||
Where can similar macro template / sample be found? | Excel Programming |