I have a range of cells (AB1:AB22) on sheet1 that I would like to copy&paste into sheet2.
On sheet2 the target range is on the same row but from Column (D:Z).
Which row on sheet2 the result should end up in depends on the value of "FNR" which is a named cell on sheet1.
The value of "FNR" should be found in column A of sheet2 and the data pasted inte column D of that same row.
I have made macro's doing just this before in Excel4 macro language and I think I would manage to "translate" them into VBA myself but I really don't want to use the Copy&Paste stuff now that I'm getting used to just use "Range(x) = Range(Y).value" instead of "Copy Range(x) then select Range(Y) and paste.
I have named my range (AB1:AB22) "Export" and would like to copy that range (transposed) into column D but not just in any row.
How would I write the code to first determine the right row and then export the range ?
I want this procedure to be done just by pressing a button without me leaving sheet1. It's actually an update of an Excel database we are talking about here. Sheet1 is the form.
What should happen if the code can't find the value of "FNR" in column A of sheet2 ?
Well, I think the best solution would be that it added the missing value to the bottom of column A of sheet2 (as a new post) and continued from there.
I'm sure someone out there can save me a couple of hours of trial & error.
Managing Active Directory does not always have to be complicated. If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why
Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure:
First, sum up all the individual digits in the number
If that sum value has more than one digit, then sum up …
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…