LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Excluding VAT for selected item

I am using a spreadsheet which uses a macro to copy and pasted products onto
a selected area on the same worksheet. One of the items requires 0 VAT. Is
there anyway this can be achieved when the item could appear in one of 46
rows, it is always the last item to be shown on the pasted list, although it
is dependant on what is pasted above it as to which row it will be pasted.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort bar chart in excel BuriedInSpreadSheets Charts and Charting in Excel 6 May 31st 07 04:12 PM
Fill in form to type Item descrictions and costs and fill in funct cradino Excel Worksheet Functions 0 July 16th 06 08:44 PM
Most frequent item in a list (excluding zeros) Andre Croteau Excel Discussion (Misc queries) 3 November 12th 05 06:58 PM
Need to sum up numerous columns in different worksheet into 1 devil135 New Users to Excel 3 May 26th 05 03:32 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"