| Author |
Message |
Forum: Support Topic: Copy pasting need help with controls / mouseposition |
| sheeblasta |
|
Posted: May 16th, 2011, 3:01 pm
|
|
Replies: 2
Views: 151
|
| WinWait, Personal Touch Home Care Services`, Inc - QuickBooks Enterprise Solutions: Professional Services Edition 9.0(multi-user)(Austin) x:: Sleep 50 click left 2 sleep 100 Send, {CTRLDOWN}c{CTRLUP} Sleep 75 Mousemove 616, 136 Sleep 325 Mouseclick, right Sleep 1... |
|
 |
Forum: Support Topic: Transfer data from one excel to another |
| sheeblasta |
|
Posted: September 10th, 2009, 7:18 pm
|
|
Replies: 9
Views: 2407
|
=Sheet1!$A$2:$A$179
='Sheet2'!$D$8:$D$197
=VLOOKUP(Sheet1!A2:A179, Sheet2!D8:D197,1,FALSE)
This is not working right, I start the formula in d9 sheet 2 and drag it down and it just copys names starting at row 8 in d8 from sheet 1 instead of comparing A2 etc why is this? |
|
|
Forum: Support Topic: Transfer data from one excel to another |
| sheeblasta |
|
Posted: September 10th, 2009, 5:20 pm
|
|
Replies: 9
Views: 2407
|
| does Vlookup actually enter data or just check it? i have this, These are the name columns that need to be compared, but i need some kind of delimiter because sheet 1 names are different bc of -M on the end of their name for Medicaid. =Sheet1!$A$2:$A$179 ='Sheet2'!$D$8:$D$197 which needs to be compa... |
|
|
Forum: Support Topic: Transfer data from one excel to another |
| sheeblasta |
|
Posted: September 10th, 2009, 7:09 am
|
|
Replies: 9
Views: 2407
|
| I am just using patient last name with their weekly hours. Its just a billing sheet. I want to take the exported data off of quickbooks and enter it into the billing sheet. |
|
|
Forum: Support Topic: Transfer data from one excel to another |
| sheeblasta |
|
Posted: September 9th, 2009, 9:35 pm
|
|
Replies: 9
Views: 2407
|
| I know that MS excel 2007 have these capabilitys but at work I only have excel 2000, once i get the picture of how to transfer data based on the variable I have huge potential in lowering my work load. I have made my own COM scripts that start programs and commands within the browser but I depend to... |
|
|
| Sort by: |
Login
Register
FAQ
Search