Excel : Copy entire row to different sheet using VBA -


i seeking excel vba expert.

i have attached excel file reference.

in "input" sheet there production schedule generated on submit button click. , same schedule have copied in "output" sheet. not able paste in desired location (blue highlighted area).

another challenge me retain relevant data corresponding year , clear rest. means suppose schdule 34 years, if again generate 20 years keep values of class , class ii till 20 years , clear rest.

the same has in output sheet also.

some 1 please @ earliest.

thanks , regards,

santosh

the code within submit_click:

**sub submit_click() `enter code here`dim no_years integer dim i_val integer range("c10").activate  activecell.entirerow.clear  activecell = range("b3").value no_years = range("b4").value i_val = range("b5").value   while no_years > 0 activecell.offset(0, 1).activate activecell.value = dateadd("yyyy", i_val, activecell.offset(0, -1).value)  no_years = no_years - 1  loop  ' copy production schedule calender sheets activecell.entirerow.copy destination:=sheets("output").range("a" & rows.count).end(xlup).offset(1)  msgbox ("production schedule calendar generated") end sub**

the easy way this:

activesheet.rows("1:1").copy sheets("output").paste

is you're looking for?


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more