Hi,
I have a problem with VBA code for pasting const value. Please see attchaed file. In sheet1 I have values in column A. I need to copy them to sheet2 and there in column B be there should be always value a, in column b value c etc for each value from sheet1. Could you please help with this issue?
Thanks in advance.
Best regards
Jarek
It is not clear at all what you mean by this. What do "value a" and "value c" mean? How does this relate to Sheet1? It might help if you showed in your file what you want the result to look like.Originally Posted by surferj24
Hi,
Yes you right. That wasn't clear. Please see now attached file with result that i wnt to achieve. In sheet1 I have cells in column A with some values. i want to copy them to sheet2 but in column B for each value from sheet1 will be b, in column C value c etc. I hope this is clear.
Thanks in advance for oyur help.
You said "copy" but I don't know if you meant to literally copy them or to be able to dynamically keep them up to date as Sheet1 changes. This example uses formulas on Sheet2 to replicate the data on Sheet1 and add a/b/c/d for non-blank entries. In this example the formulas go to row 10 but you can fill them down to as many rows as needed.
You posted in a VBA forum but I have provided a formula solution. If this doesn't solve your problem then I guess you will need to provide a more detailed explanation of how you will use this.
Hi,
First of all thx for your reply. Yes I also thought about formula solution but it will not work for me. Values from sheet1 should be copy to sheet2 and they should have constant values as I showed:
in column A it should have "a" for each copy record from sheet1. In column B it should be value "b" for each record copied from sheet1 ect. However every time I open ecel file I will maintain different values in sheet1 and I want to have clear sheet2. Also function "copy" should be trigger from a button. So that's why I need macro code for this.
BR
Jarek
What behavior do you want after several rows have been copied, then data on Sheet1 changes? Examples: rows are all deleted then new rows are added. Data in column A of an existing row is changed.
Do I understand correctly that you want Sheet2 to be cleared every time you open the file? What about the data on Sheet1?
I will certainly help with the code when I get a few minutes but I still don't see how your need isn't met by formulas, other than the clearing part.
Yes it should be exatly as you wrote. All data in sheet1 and sheet2 will be deleted everytime after I will finish work on this file. So basically when I open file there will be no data.
someone has got some idea about this?
problem has been solved thx for your support 6StringJazzer
Glad to hear you have it solved, sorry I couldn't get back sooner.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks