Search:

Type: Posts; User: deanl33069; Keyword(s):

Page 1 of 4 1

Search: Search took 0.01 seconds.

by deanl33069
Replies
1
Views
99

Auto-fill

I have a dropdown list on sheet 1 , the data is on sheet 2.
is there a way of making the list autofill?

by deanl33069
Replies
13
Views
1,689

Re: Copy formula

Tyvm!!!!

by deanl33069
Replies
13
Views
1,689

Re: Copy formula

TY all , I believe that did it!!!!
Can u plz explain what the formula does ,looks weird.

by deanl33069
Replies
13
Views
1,689

Re: Copy formula

did not copy right filled each line the same formula

by deanl33069
Replies
13
Views
1,689

Re: Copy formula

fIRST LINE IS ALL \$AA6
second is \$AA7 ect

by deanl33069
Replies
13
Views
1,689

Re: Copy formula

ty but didnt work

by deanl33069
Replies
13
Views
1,689

Copy formula

I have a simple formula starting in column AD6-AQ6
in AD6 i have =aa06 AE6 =aa07 AF6 =aa08 ect
it stops in cell AQ6 then drops down to AD7 over to AQ7 then down to AD8-AQ8
when i copy cell AD6 and...

by deanl33069
Replies
14
Views
419

Re: Formula copy

6 aa6 =aa6 =aa7 =aa8 =aa9
7 aa7
8 aa8 ...

by deanl33069
Replies
14
Views
419

Re: Formula copy

my number...lol
My print field is ab1-aq38
i need column aa starting (AA6) to copy into ac6-aq38 if data is present.

by deanl33069
Replies
14
Views
419

Re: Formula copy

no, I need aa6 to copy into ac6
so that the column aa6-aa360
copies to ac6-aq38
right now just copies straight across or lose formula.

603-505-1753

by deanl33069
Replies
14
Views
419

Re: Formula copy

i need aa6 to be ac6
aa8 to be ae6
aa9 to be af6
and only fill 10 rows across
then start below ac6

ac6 ac7 ac8 ac9 ac10 ac11 ac12 ac13 ac14 ac15
ac16 ac17 ac18 ac19...

by deanl33069
Replies
14
Views
419

Re: Formula copy

ok so when i copy and paste the formulas do not follow , so instead of AA6 going to ac6 it changes to=(AB6). If i do a copy and paste values it doesn't scroll down just fills in to the right.

by deanl33069
Replies
14
Views
419

Formula copy

OK i will try to explain this,
in column AA6 to AA320 i have a formula of =(k6) all the way down to k320
i need to copy AA6-AA320 into cells AC6toAQ6 acroos then down to aq50

HELP

by deanl33069
Replies
10
Views
349

Re: Formula check

I have not created oned yet I want to know the best way to do this .....ty

by deanl33069
Replies
10
Views
349

Re: Formula check

No
these are inside a module 9 , I want to create a drop down menu using thes 4 different formulas

by deanl33069
Replies
10
Views
349

Re: Formula check

so i have used 4 different scripts i would like to make a drop down menu to select which script to use....tyvm
1)Sub w3202L()xxxxxxxx
2)Sub w3201L()xxxxxxxx
3)Sub w3102L()xxxxxxxx
4)Sub...

by deanl33069
Replies
10
Views
349

Re: Formula check

TY Everyone this is working well......I did 4 different formulas from the statement.
How can i create pull down menu to select different ones?

by deanl33069
Replies
10
Views
349

Formula check

I have this formula

Sub w3202L()
'
' w3202L Macro
'

'
Sheets("Misc").Select
19. Thread: macro from drop down list

by deanl33069
Replies
2
Views
78

Re: macro from drop down list

I tried to insert a drop down box , but it was grayed out.......:(
20. Thread: macro from drop down list

by deanl33069
Replies
2
Views
78

macro from drop down list

I have 4-6 marcos that i want to be able to choose from in a drop down list.

by deanl33069
Replies
3
Views
135

Formula to right

I have this formula in cell Ac2......=(aa2)
in cell ad2 in have .....=(aa3)
cell ae2...... =(aa4)
how can copy formula to into cells ? it changes the format of the formula so instead of ad2 ...
22. Thread: Help conditional formatting not working

by deanl33069
Replies
9
Views
201

Re: Help conditional formatting not working

It works but does not update automatically.
23. Thread: Help conditional formatting not working

by deanl33069
Replies
9
Views
201

Re: Help conditional formatting not working

010089677500277211180619310100181421091643
3333
010089677500277211180619310200181421091636

010089677500277211040719310200181421002815
010089677500277211040719310200181421002803...
24. Thread: Help conditional formatting not working

by deanl33069
Replies
9
Views
201

Help conditional formatting not working

I have a bunch of unique numbers in cells a2:a310. they are from a barcode scanner.
the first 10 numbers are the same and the rest are different . when i highlight column A and set conditional...