Search:

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

Page 1 of 6 1

1. Thread: Chart based on Store selection

by igold
Replies
2
Views
151

Re: Chart based on Store selection

I think your problem lies in how you have your data laid out. If it were me, I would have 3 Columns of data. The header row would be STORE#, DATE, SALES. I would then move the sales data to the...
2. Thread: Searching an array for a match

by igold
Replies
5
Views
116

Re: Searching an array for a match

You're welcome.
3. Thread: Copy rows based on keyword list to second sheet

by igold
Replies
10
Views
197

Re: Copy rows based on keyword list to second sheet

I am sorry I could not be more help. At least you got a bump out of it and Fluff got it done for you.

Thanks for the feedback.

by igold
Replies
10
Views
197

Fluff

Nice!

igold
5. Thread: Copy rows based on keyword list to second sheet

by igold
Replies
10
Views
197

Re: Copy rows based on keyword list to second sheet

I downloaded your workbook, and it is not as described in your post. You have the software name, version number, department name all in column A separated by commas. I can break that information out...
6. Thread: Why won't this return a BLANK cell?

by igold
Replies
5
Views
179

Re: Why won't this return a BLANK cell?

Have you clicked on the Fx button to the left of the formula bar while your formula is in the bar to see what each part of your formula is returning...
7. Thread: Why won't this return a BLANK cell?

by igold
Replies
5
Views
179

Re: Why won't this return a BLANK cell?

Out of curiosity, with the same data that you are using for the IF statement in your OP =IF(OR(F3>0, O3>0,F3-((IF(SUM('Week 42:[Week 52]Week 52'!P3)>0,SUM('Week 42:[Week 52]Week 52'!P3))))), " ") ...
8. Thread: Copy rows based on keyword list to second sheet

by igold
Replies
10
Views
197

Re: Copy rows based on keyword list to second sheet

You are welcome, I was happy to help.

If it does not work for you, let us know and I am sure a solution can be found.
9. Thread: Copy rows based on keyword list to second sheet

by igold
Replies
10
Views
197

Re: Copy rows based on keyword list to second sheet

How about something like this. The software list you want to search for should start in Cell A1 on Sheet3.

Sub GetSoftware()

Dim ws1 As Worksheet: Set ws1 = Worksheets("Sheet1")
...
10. Thread: Why won't this return a BLANK cell?

by igold
Replies
5
Views
179

Re: Why won't this return a BLANK cell?

I can't say for sure why it is returning zero, you may have a stray character in one of your cells. I can say for sure, that you are missing the "Value if False" part of your IF statement.
11. Thread: Searching an array for a match

by igold
Replies
5
Views
116

Re: Searching an array for a match

There are lots of ways to get the UPC and Date that you want to search for into the search, I chose an InputBox. This code assumes that your first UPC,Date,Price row starts in Cell A2.

Sub...
12. Thread: Run formula if text is found in a cell.

by igold
Replies
6
Views
56

Re: Run formula if text is found in a cell.

Yongle

It was the red highlighting that did you in. :stickouttounge:
13. Thread: Run formula if text is found in a cell.

by igold
Replies
6
Views
56

Re: Run formula if text is found in a cell.

Is this what you are looking for...

=IF(L2="open",IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past Due",IF((TODAY()+7)>E2,"Due Soon","")))),"")
14. Thread: Find Multiple Command For VBA in Excell

by igold
Replies
2
Views
74

Re: Find Multiple Command For VBA in Excell

You could use a manual or a VBA AutoFilter with multiple criteria. From this part of your post

it seems like you are probably wanting to copy the rows to somewhere else, which an AutoFilter...
15. Thread: Vba for each cell in rng insert dynamic formula

by igold
Replies
8
Views
238

Re: Vba for each cell in rng insert dynamic formula

You're welcome.
16. Thread: Vba for each cell in rng insert dynamic formula

by igold
Replies
8
Views
238

Re: Vba for each cell in rng insert dynamic formula

If I understand your requirement, does this do what you want...

Sub test()

Dim arr
Range("B2").Formula = "=sum(B\$1,\$A2)"
Range("B2").AutoFill Range("B2:B517")
arr =...
17. Thread: Vba for each cell in rng insert dynamic formula

by igold
Replies
8
Views
238

Re: Vba for each cell in rng insert dynamic formula

This...

Sub test()

Range("B2").Formula = "=sum(B\$1,\$A2)"
Range("B2").AutoFill Range("B2:B517")

End Sub

by igold
Replies
7
Views
387

Re: Help Needed for unique task

How about the actual line of code. Your line 42 is not necessarily my line 42...

or was there additional info provided...
19. Thread: Which one cost more memory to run?

by igold
Replies
4
Views
243

Re: Which one cost more memory to run?

You're welcome, and yes the speed difference would be exponential. The reason being that with an array all work is being done in memory, while having your code going back and forth to the sheet to...
20. Thread: Which one cost more memory to run?

by igold
Replies
4
Views
243

Re: Which one cost more memory to run?

The way you phrased your post, I am not 100% sure of what your asking. You say that you are used to storing data in arrays, but of course when you re-run the macro, the data is erased and re-written...

by igold
Replies
3
Views
208

Re: Returning a Share Price from Google

You may want to take a different approach...

I have created a public google spreadsheet which consists of my symbol list and the info I wish to return using the built-in google finance functions...

by igold
Replies
7
Views
387

Re: Help Needed for unique task

Do you know which line threw the error.
23. Thread: Searching in Excel crashing/Flickers

by igold
Replies
5
Views
69

Re: Searching in Excel crashing/Flickers

Ok, I have no other suggestions. Sorry I could not be any more help.
24. Thread: Searching in Excel crashing/Flickers

by igold
Replies
5
Views
69

Re: Searching in Excel crashing/Flickers

I still say 9mb does not sound right. I have a sheet with over 250,000 rows and 10 columns and it is only 5.75mb. Go to each sheet and hit CTRL+END and see...
25. Thread: Searching in Excel crashing/Flickers

by igold
Replies
5
Views
69

Re: Searching in Excel crashing/Flickers

I can't explain all the different scenarios you have listed, but in your closing you say that your spreadsheet is 9MB with only 6460 rows. That right there sounds awfully suspicious. I would check...
Results 1 to 25 of 150
Page 1 of 6 1