Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Some help with a workbook please
Hello any assistance provided is greatly appreciated.
I would like to write a formula, or code where I can have cell c15 on sheet A equal cell A1 on sheet B if Cell B1 = incorrect and cell c2 = 5164. So more exactly: If b2=incorrect and c2=5164 then copy a1 from sheet dec to sheet corporate c5 The part that makes this the most difficult is that c2 on sheet dec will change aproximately every 140 rows, and will contain up to 2 thousand entries. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Some help with a workbook please
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. I'll look tomorrow -- Don Guillett Microsoft MVP Excel SalesAid Software "Courtney" wrote in message ... Hello any assistance provided is greatly appreciated. I would like to write a formula, or code where I can have cell c15 on sheet A equal cell A1 on sheet B if Cell B1 = incorrect and cell c2 = 5164. So more exactly: If b2=incorrect and c2=5164 then copy a1 from sheet dec to sheet corporate c5 The part that makes this the most difficult is that c2 on sheet dec will change aproximately every 140 rows, and will contain up to 2 thousand entries. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows. | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |