Hi guys,
I would like to copy paste entire row from king sheet to queen sheet if the
cells in range "B2:B" has the value of "update" in king sheet. However, I
have copy area and paste area not same size error. May I know how can I
solve this? Can anyone help? Thanks in advance.
Cheers
--
Ar
Hi Paul,
Thank you for your reply. Thanks a lot for your suggestion. I've changed to
use another way for the time being.
Hope you have a very nice day!
Cheers
On Thursday, 18 February 2016 20:59:51 UTC+8, Paul Schreiner wrote:
>
> "Without opening the file manually"..
> I think there's a way
FYI...This is resolved. The problem occurred because within my formula I
included the sheet name. Upon removing the sheet name from the formula the
sorting functioned properly.
Rob
On Tuesday, February 9, 2016 at 4:05:06 PM UTC-8, robf...@gmail.com wrote:
> I am working with Excel 2013 and am
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Senior developer with SCADA and someone with experience in a Pipeline
company.*
*Houston TX*
*12+ Months*
*Need Locals*
*.Net Developer - *On behalf of our client in the Oil and Gas sector we are
looki
"Without opening the file manually"..I think there's a way to do that, but from
what I understand the technique still requires the excel file with the macro to
be open.
Instead, you can write macro that tests for the current date/time and changes
the cell when the file is opened.(it would then s
If you REALLY want to shorten your formula:
the =concatenate() function is a "throwback" to earlier versions of excel and
only included for "backward compatibility".
"technically", these two are the same
thing:=CONCATENATE("AB",TEXT(I2,"0"))="AB" & TEXT(I2,"0")
Paul---
Dear All,pls guide me above issue & How many name range we kept in
excel,there are any limitation?
On Wed, Feb 17, 2016 at 2:14 PM, amar takale wrote:
> Dear Mandeep,I want also VBA Code create unique sector name range in sheet
>
> On Tue, Feb 16, 2016 at 5:38 PM, amar takale wrote:
>
>> Dear M