HELP about macro copy and paste [[Solved](/forum/excel-140/solved)/Closed]




 Hello, 
  

  
Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw and colunm as below example.i will use this formula in serveying as a use a form in sheet one and one i enter the detail in sheet one it is automatically copy to sheet 2 and save.then when i enter new data it is authomatically paste in the last empty raw.
  

  
i want to copy the below cell in grp A and paste to grp b as ff.
  

  
 A B
  

  
 d11 a1
  
 f6 b1
  
 g7 c1
  
 b23:i23 d1:k1
  
 b24:i24 d2:k2
  
 b25:i25 d3:k3
  

  
Hope it makes sense. I have very little knowledge in writting VB but can manage to read and understand the simple ones. Could anyone help me with a macro that will do this automatically? 
  

  
Your usual help and support will highly appreciate.
  

  

  
Thank you in advance
  

  
Marvs.
yes for current region you can use a range 
  
something like this 
  

  

  

```
With Worksheets("sheet1")
.range("A1:e10").copy
```

  

  
the dot before "range" is important.
  

  
it will copy only from A1 to E10. modify to suit you
hi,we have no formal “copy file type and template” from environment test to prod.this is what i’ve done hundreds of times.assuming you created a new file type or copied an existing template. - do this same process in prod (or the other environment), ideally keep the same name and description - just keeps things clean.then update the tabs so the file separator and date formant is the same. if you created any external file template controls update this as well,finally, - in the file template details, i delete all records in the new prod, and then use the copy / past object to copy the details from test to prod. rather than analyzing to see what’s different in the details between test and prod, if we know test works, i would typically delete the details and copy object from test to prod.if you had any formula in test you can manually copy these as well. it’s a few steps, but it only takes a couple minutes. best regards,thomas i would do it like this:

https://www.advanced-excel.com/columns-to-rows.html it's not clear what it is you want as an output. if it's a row vector, there's no concatenation involved, you just simply reshape your matrix:
a = [0 1 1 1;
 1 0 1 0;
 1 0 0 1]
 v = reshape(a, 1, []) %reshape a into one row. since matlab is column major, this is done column-wise Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. You will probably need to write a VBA macro that does this. Formatting is not pushed down from the workbook that the user opened to the workbook that holds the source data. direction: a word and number arrangement machine when given an input line of word and numbers rearranges them following a particular rule in each step. the following is an illustration of input and rearrangement. input: politics 61 policy 116 partner 93 role 45 clear 27 38 point step i: role politics policy 116 partner 93 45 clear 27 38 point 61 step ii: role clear politics policy partner 93 45 27 38 point 116 61 step iii: role clear partner politics policy 93 45 38 point 27 116 61 step iv: role clear partner politics policy 93 38 point 45 27 116 61 step v: role clear partner politics point policy 93 38 45 27 116 61 step v, is the last step of the above arrangement as the intended arrangement is obtained. as per the rule followed in the given steps find out the appropriate steps for the given input. input: energy 54 78 place 23 issue 211 145 flat rent taxi 17in step iii, what is the difference between fifth element from left and second element from right? Should be able to do something like this:


UPDATE table\_name  

SET new\_column = (calculated value)  

WHERE new\_column is NULL hi, @ricky007 
create table bill\_stag
(
s\_categry varchar2(20),
s\_billnum varchar2(20)
);

insert into bill values('1111','5647859541785');
watch out! you're using two different table names there.
you don't care which m\_billnum\_seq gets assigned to which new row, do you? (you shouldn't.) in that case, you can simplify the cross join approach that cormaco suggested like this:
insert into bill\_mast (m\_bill\_seqnum, m\_billnum, channel) -- always name the columns
with  all\_channels  as
(
 select 'mob' as channel  from dual  union all
 select 'atm'      from dual
)
select  seq\_num.nextval
, s.s\_billnum
, c.channel
from     bill\_stag    s
cross join all\_channels c
;
you don't need order by, so you don't need the ord column and you don't need so an extra sub-query. as long as you write down the hierarchy manually, there’s certainly the possibility to simplify such transitive from implementations with a macro. [i’ve written one here, feel free to take a look.](https://play.rust-lang.org/?version=stable&mode=debug&edition=2018&gist=337cce675aa28e99ac030ca783c1c155) going even further one could try to use procedural macros with global state that uses annotations on the… g = findgroups(yourtable.name);
output = splitapply(@(varargin) {table(varargin{:}, 'variablenames', yourtable.properties.variablenames)}, yourtable, g);
this should give a cell array of tables.